Subject | Re: [ib-support] SET GENERATOR issue |
---|---|
Author | Helen Borrie |
Post date | 2002-09-06T01:50:58Z |
At 01:34 AM 06-09-02 +0000, you wrote:
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
>Hello,IB_Cursor represents a single SQL statement. If you need to submit batches
>
>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?
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