Oh well I understand. Thanks for your support !!

Matthias Feist

Nick Upson schrieb:

>
> by 'last' I assume you mean the highest value of ID
>
> so in your SP determine the last record to ignore in one loop then do
> your actual retruning data select loop that only returns the records
> with an ID greater than the ID you determined in the first loop
>
> On 06 Mar 2007 04:17:55 -0800, Matze <mailinglist@...
> <mailto:mailinglist%40matf.de>> wrote:
> > Hi Firebird-Folks ;-)
> >
> > I hava a Problem: I have to create a sort of a account in my Database.
> > The table looks like this:
> > ID User_id Text Amount
> > 1 1 test 5
> > 2 1 test2 3
> > 3 1 test3 -8
> > 4 1 test 10
> >
> > I want to create a stored Procedure, which creates an output of this
> > account since the last amount sum of 0.
> > To explain that:
> > The result of this example shoult be 10, because the result should begin
> > after the last line of 0 and 5+3+8=0.
> > How can I do this?
> > My Idea was, to sum up the amount in a loop and if the sum reaches 0
> > clear the output dataset, but I dont know how.
>
>