I need to use the cursor to do an inventory calculation which I need
to calculate the accumulative quantity balance, rates and the amount
of each inventory code with a set a formulars.

My plan was to use two set of cursors one is to collect all the
inventory codes and the second set is to get all the transactions
base on the fetch next inventory code to do the calculation.

Can this be done in FB1.5?



--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 05:13 AM 22/04/2004 +0000, you wrote:
> >I am converting my existing SQL Database to FB1.5. I found that I
> >cannot declare cursor in the store procedure. Is this a bug or

there

> >is another way of declaring cursor?
>
> Better you explain what you want to achieve. Firebird implements

cursors

> in two ways: the one you choose to use depends on the task.
>
> As you're probably aware, there is no standard for stored
> procedures. Every RDBMS has its own way to do things...do you

have the IB

> 6 beta Language Reference (LangRef.pdf)?
>
> /heLen