Subject Re: [firebird-support] Re: need help - can't re-create stored procedure...
Author Daniel Rail
Hi,

At December 6, 2004, 16:38, zamb1zz1 wrote:



> Alright, but here's an example, I just tried to create the sproc I
> posted earlier - without quotes. I get an error, here's the error &
> sproc:

> ISC ERROR CODE:335544569

> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 22, char 18
> _order_id

Each database object and variable has to start by an alphabetic
character(A-Z,a-z). It's in the IB6 Language Reference Guide.

I usually start my variables with the character "v", just as an
indicator that it is a declared variable. That's my personal
preference.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)