Subject Re: [firebird-support] Set generator in execute block
Author Thomas Steinmaurer
>> **
>>> This is expected for DDL statements in PSQL.
>> OK thanks for the info there
>>
>
>>>> I have tried wrapping it in an EXECUTE STATEMENT block to the same
>> effect.
>>
>>> This should work. What error message do you get here?
>> exactly the same error :-(

I can run the following just fine with 2.5.2 Snapshot.

set term !! ;
execute block
as
begin
execute statement 'set generator g_t1_id to 12';
end
!!

set term ; !!


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

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