Hi Martijn,

Yep, tried that already, and still get the same message!

Any other ideas?

Many thanks,

David




"Martijn Tonies" <m.tonies@...> on 22/10/2003 02:28:30 PM

Please respond to firebird-support@yahoogroups.com

To: <firebird-support@yahoogroups.com>
cc:
Subject: Re: [firebird-support] Re: Stored Procedures?


Hi,

> thanks for the reply...but this doesn't compile! (RC5)
>
> I added as "AS" which I think I need, but I still get the following error
> on the code below:
>
> CREATE PROCEDURE MY_PROC(CAT_ID INTEGER)
> RETURNS (ID INTEGER, TITLE VARCHAR(100),EXP_DATETIME TIMESTAMP)
> AS
> BEGIN
> FOR SELECT id, title, ExpirationDateTime
> FROM forms INNER JOIN formcategory
> ON forms.id=formcategory.form_id
> WHERE category_id=:CAT_ID
> ORDER BY UpperTitle
> INTO :ID, :TITLE, :EXP_DATETIME;

Remove the last ";" here.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL
Server.
Upscene Productions
http://www.upscene.com



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/