At 10:56 AM 10/12/2001 +0200, Gerhardus Geldenhuis wrote:

>What would be the typical application of a cursor. When is it a good idea
>to use and when not. I cant see the difference between a cursor and a
>select statement to me it appears as if they achieve the same goal.

A cursor is a way to iterate through a select statement in a program.
In InterBase stored procedures the

FOR SELECT <stuff> INTO <places>
DO BEGIN
<whatever>
SUSPEND;
END

is equivalent to a cursor. Most higher level interfaces include
some sort of iteration around a select.


Regards,

Ann
www.ibphoenix.com
We have answers.