Re: creating stored procedures using ISQL
"Greg Laurin" <glaurin@coldstorage.com> wrote:
>This is something that sounds to simple but I can't create a stored
>procedure in ISQL
>
>I tried -
>CREATE PROCEDURE test()
>END PROCEDURE;>
>and it works, OK I tried -
>
>CREATE PROCEDURE test(ltqty INT)>
>let ltqty = ltqty / 2; -- I also tried it without the ;
>
>END PROCEDURE;
>
>and it gives me a syntax error, Why ?
>
>
>I have looked in all the manuals for I4GL 4.01 and ISQL 4.02 and there is
>nothing, absolutely nothing on stored procedures :(
>
>Thanks In advance for helping me with this simple and dump question
>
>Doug Gray
>penngray@netrover.com
>
>
>
Try using DBACCESS instead of ISQL.
***************************************************************
Jay Aymond
United Life & Annuity Insurance Company
Email: jay@ulife.com
***************************************************************