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