Re: DECLARE CURSOR...

Martijn Tonies wrote:

> Hi,
> 
> According to the Language Reference, DECLARE CURSOR
> should be available in DSQL. Am I missing something here, but
> I cannot get it to work.

That is a documentation error. Cursors are only available in the API.
In SQL you must use FOR SELECT/DO.

-- 

	IIRC there's an undocumented WHERE CURSOR OF feature in the stored
procedure and trigger language, but it isn't actually useful for
anything.

-- 
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Useful articles about InterBase development:

	You can do the same thing with rdb$db_key; I don't really see any
advantage to where current of.

-- 
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
IB 6 versions prior to 6.0.1.6 are pre-release and may corrupt 

Hi,

According to the Language Reference, DECLARE CURSOR
should be available in DSQL. Am I missing something here, but
I cannot get it to work.

-- 
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

	I agree that the syntax is cleaner, but it's the unsupported bit which
makes me avoid it.

-- 
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Please read and follow Borland's rules for the user of their