| Subject | Re: error in execute statement into with generator id |
|---|---|
| Author | intellekta |
| Post date | 2006-02-19T11:43:01Z |
sorry i simplify the SP this is the corrected with the same error
CREATE PROCEDURE NEWTABLEID (TABLENAME VARCHAR(50))
RETURNS (NEWID BIGINT)
AS
DECLARE VARIABLE TMPSQL VARCHAR(4096) CHARACTER SET NONE;
BEGIN
TMPSQL = 'SELECT GEN_ID(GEN_' || TABLENAME || '_ID,1) FROM RDB$DATABASE';
EXECUTE STATEMENT TMPSQL INTO :NEWID;
END
CREATE PROCEDURE NEWTABLEID (TABLENAME VARCHAR(50))
RETURNS (NEWID BIGINT)
AS
DECLARE VARIABLE TMPSQL VARCHAR(4096) CHARACTER SET NONE;
BEGIN
TMPSQL = 'SELECT GEN_ID(GEN_' || TABLENAME || '_ID,1) FROM RDB$DATABASE';
EXECUTE STATEMENT TMPSQL INTO :NEWID;
END
>
>
> (assuming you left out the defin of tmpsql)
>
> --
> Nick
> -----We Solve your Computer Problems---
> UNIX, C, Panther, Ingres, Interbase, Firebird - Available Shortly
>