FireBird's native dynamic SQL und Variablen

[Stevie]

Moin Robert,

SQL-Code:

SET TERM ^ ;
CREATE PROCEDURE GETID (TableName VARCHAR(55)) RETURNS (NewID BIGINT)
AS
BEGIN 
  EXECUTE STATEMENT 'SELECT GEN_ID(GEN_'||:TableName||'_ID,1) FROM RDB$DATABASE' INTO :NewID;
  SUSPEND; 
END
^ 
SET TERM ; ^

MfG
Stevie