Re: creating stored procedures w/ isql 4.11
>
> I am getting a syntax error when trying to create a stored procedure in
> ESQL 4.11. It works in DBACCESS 5.01. I am using Online 5.01.
>
> Here is the script:
>
> CREATE PROCEDURE VLD_SITE(aSiteId INTEGER, ErrMsg VARCHAR(70))>
>..
>
> END PROCEDURE;
>
> Has anybody gotten this error? Is this a bug or does ISQL 4.11 not support
> stored procedures?
>
> Rick Hamel
Rick,
No V4 software can recognise Stored Procedures as these were not
implemented until V5. You can get round this problem though by
putting the whole stored procedure into a text string and using
prepare and execute. This way no syntax checking is done by the front
end tool it just packages it up and sends it to the backend which will
perform the command for you, as long as it is valid syntax!
Cheers - Jim
My opinions are my own. They may vary with time but they remain MINE!
----------------------------------------------------------------------
Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM
Company: DHL Systems Inc Phone: (415) 375-5222 (Work)
Address: 700 Airport Blvd. #300 (415) 775-7762 (Home)
Burlingame, CA 94010-1937 Fax: (415) 375-5019
----------------------------------------------------------------------