[firebird-support] Set generator in execute block

[Si Carter]

Hi,

When trying to execute the following it produces an error:

SET TERM ^ ;

EXECUTE BLOCK
AS
  DECLARE VARIABLE vMaxID BIGINT;
BEGIN
  SELECT MAX(ID) FROM A_TABLE
  INTO :vMaxID;

  SET GENERATOR GEN_A_TABLE_ID TO :vMaxID;
END

SET TERM ; ^

the error being

Engine Code    : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 10, column 3
SET

I have tried wrapping it in an EXECUTE STATEMENT block to the same effect.

Is setting a generator value in an execute block not supported or am I
doing something obvious wrong?

any help appreciated.

rgds

Si