Subject Re: SP Creation
Author Svein Erling Tysvær
--- In, "Lee Jenkins" wrote:
> Hello all,
> I've not used SP's much, but with my current project, I want to make almost
> exclusive use of them. Anyway, I am having a bit of trouble with my current
> SP. I keep getting a "Variable CUSTOMERPASS unknown". If I compile anyway,
> it goes through and subsequent changes to the SP do not produce that error.
> I am using IBExpert personal so I wan to see if its something with it or my
> lack of understanding. Also this is the first time I've used a Dialect 3
> database, but do not quote out anything in DDL statements.

You don't happen to create the SP in the same transaction as the creation of the
CUSTOMER table or the CUSTOMERPASS field (I don't know whether this should work
or not, I just generally avoid doing it)?