Subject RE: [firebird-support] SP Creation
Author Helen Borrie
At 07:16 PM 6/11/2004 -0500, you wrote:

> > Are you sure it wasn't saying "Variable V_CUSTOMERPASS unknown" ?
> >
> > The thing is, CUSTOMERPASS isn't a variable. If it wasn't
> > finding a column
> > in the SELECT specification, you would have seen a different exception.
> >
> > ./heLen
> >
>100% sure, Helen. "Variable CUSTOMERPASS Unknown" was the exact error that
>I got. That is why I was so confused (and frustrated, lol, at one point).
>Is that an FB error? I know that IBExpert either prepares it before it runs
>it or maybe parses it first, so I wasn't sure if it was an error that the
>tool itself was throwing.

That seems probable. IBExpert seems to do some kind of client-side
pre-processing for its debug feature; and of course it prepares the
statement. On a prepare, the server would have returned SQLCode -206,
GDSCode 335544578 with the message "Column unknown", whether it was a
reference to a bad field name OR a bad variable name. It looks as though
the preprocessor in IBExpert doesn't go further to try to distinguish
which, and simply interprets the error as a bad variable.

>At any rate, I am just starting out building the db and I have uploaded a
>copy of the gbk to address below if you're interested in see it. I am using
>FB 1.5.1, BTW. Also, as Woody suggested, I tried calling the SP and it
>seems to be working.

Quod erat demonstrandum.