> 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

This is expected for DDL statements in PSQL.

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

This should work. What error message do you get here?

--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/