Subject | SET GENERATOR issue |
---|---|
Author | Scronkey |
Post date | 2002-09-06T01:34:22Z |
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?
-Ryan
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?
-Ryan