🚀 go-pugleaf

"Quinn Wildman (CodeGear Developer Support)" <qwildman@nospam.codegear.com> wrote:
>Assuming you have InterBase 7.5 or 2007, created a calculated field 
>using case, then order by that field. With earlier versions of InterBase 
>you'll need a stored procedure that returns a results set and you can 
>order on what it returns.
>
>aleplgr wrote:
>> asdfa
>> I have one 3 field's table: ClientID, Date1 and Date2, first I need to order it  by ClientID and for each ClientID order by Date1, then: 
>> I have to return a table with each CliendID and if the difference between the actual Date1 and next(Date2) >30 return actual Date1 else if there is no such difference >30 return the greatest Date1 for the actual ClientID. 
>> 
>> next(Date2) is the Date2 that is in the next row of the actual ClientID
>> I can create auxiliar tables for storing intermmediate results and I'm using EMS SQL Manager 2005, but don't know how to deal with this, any hint please
>> 
>
>-- 
>CREATE DOMAIN NEW_COMPANY AS CHAR(8) DEFAULT 'CODEGEAR' CHECK (VALUE <> 
>'BORLAND') NOT NULL;


Yes, I have InterBase 7.5, I don't understand the first part of your answer: "create a calculated field using case"
 is it possible to calculate the differences between the actual and the next row in a case? is there an example of that?
Thanks again