Subject Re: [ib-support] SET GENERATOR issue
Author Helen Borrie
At 01:34 AM 06-09-02 +0000, you wrote:
>Hello,
>
>I'm in the process of writing my import routines for all the data in
>a bde app which I'm upszing to Firebird.
>
>I have generators for most tables, and once the data is imported,
>I'm getting the highest imported ID, and want to set the generators
>to this value+1, so they are ready for when data begins being
>inserted into the new db.
>
>I'm using an IB_Cursor to SET GENERATOR a_gen TO x
>
>This works fine for one, but when I try to have two lines, I get an
>unknown token SET error on line 2.
>
>I've tried putting a ; after the line but this does not help. Why
>can I not have two (or more) SET GENERATOR in the SQL.Strings of an
>ib_cursor?

IB_Cursor represents a single SQL statement. If you need to submit batches
of statements in SQL you use a script. IBO has a script component.

IBO is off-topic in **this list** so I've forwarded another suggestion to
the IBO list.

heLen