Subject | Re: [firebird-support] Set generator in execute block |
---|---|
Author | Thomas Steinmaurer |
Post date | 2012-02-08T19:36:08Z |
>> **I can run the following just fine with 2.5.2 Snapshot.
>>> 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 :-(
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/