Subject | Generators and Stored Procedures |
---|---|
Author | buppcpp@yahoo.com |
Post date | 2005-06-17T06:38:36Z |
I'm having a heck of a time getting generators to work within a SP using FB
SS 1.5.2.
I'm I correct in assuming that you can not call a generator from within a SP
if you are using variables?
ex.
gen_value = GEN_ID ( :gen_name, :gen_increment);
It doesn't work as DSQL within a SP either when you use EXECUTE STATEMENT.
I think it has to do with variables.
Please tell me I'm wrong, and put me back on the correct path.
Thanks
SS 1.5.2.
I'm I correct in assuming that you can not call a generator from within a SP
if you are using variables?
ex.
gen_value = GEN_ID ( :gen_name, :gen_increment);
It doesn't work as DSQL within a SP either when you use EXECUTE STATEMENT.
I think it has to do with variables.
Please tell me I'm wrong, and put me back on the correct path.
Thanks