Thanks Anne,

No can do. Where can I get the syntax for cursor declaration and use. I am
using V2.

Regards,
Dion.




-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: 08 January 2006 07:27 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Cursor

Dion wrote:

> How do I join 2 tables in a stored procedure using firebird. Assigning
> cursors to variables and doing a join works in MSQL. Can I do this in FB?

Cursors are part of stored procedures in V2. But why not just use the
normal join syntax?

Regards,


Ann



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links






--
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.1.361 / Virus Database: 267.14.7/214 - Release Date: 2005/12/23


--
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.1.361 / Virus Database: 267.14.7/214 - Release Date: 2005/12/23