🚀 go-pugleaf

Sorry, didn't quite grasp the question here. A calculated field can only 
calculate based on values in the current row. You'll definitely need a 
stored procedure here.

aleplgr wrote:
> "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
> 
> 
> 
> 
> 
> 
> 
> 
> 

-- 
CREATE DOMAIN NEW_COMPANY AS CHAR(8) DEFAULT 'CODEGEAR' CHECK (VALUE <> 
'BORLAND') NOT NULL;