Re: creating stored procedures w/ isql 4.11

Rick Hamel writes: |> I am getting a syntax error when trying to create a stored procedure in |> ESQL 4.11. As well you should. Stored procedures are not supported in 4.11 products, at least not directly. If you insist, then sprintf your create procedure code to a char host variable, prepare that variable and execute it. E.g. $char bbuf[10000]; sprintf(bbuf, "CREATE PROCEDURE VLD_SITE(aSiteId INTEGER, ErrMsg VARCHAR(70))");/* string is truncated for space savings */ $prepare p1 from $bbuf; $xecute p1; |>It works in DBACCESS 5.01. I am using Online 5.01. Then use dbaccess. Or buy esql 5.01. Dave Disclaimer: The opinions expressed in this message are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. **************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney