Hi,

can anybody tell me why this statement works

SELECT GEN_ID(GEN_MYTABLE_ID, 1) AS NID FROM RDB$DATABASE INTO NEWID;

but this not ?

SQL = 'SELECT GEN_ID(GEN_MYTABLE_ID, 1) AS NID FROM RDB$DATABASE';
EXECUTE STATEMENT SQL INTO NEWID;

error

"Variable type (position 0) in EXECUTE STATEMENT 'SELECT
GEN_ID(GEN_MYTABLE_ID, 1) AS NID FROM R' INTO does not match return."

Thanks in advance
Uwe Cramer