Subject | No SavePoints for FB 1.0x? |
---|---|
Author | Robert DiFalco |
Post date | 2005-01-07T00:28:27Z |
I'm not using FB 1.5 but need something akin to save points. Basically,
I am inserting a bunch of data using a transaction. If one of those
inserts results in a duplicate key exception, I'd like to continue
processing the batch but without that one insertion.
Is there a way to do something like this without savepoints? I'd really
like to avoid committing each insert individually or (worse yet)
querying for an existing record before each insert. Suggestions?
R.
I am inserting a bunch of data using a transaction. If one of those
inserts results in a duplicate key exception, I'd like to continue
processing the batch but without that one insertion.
Is there a way to do something like this without savepoints? I'd really
like to avoid committing each insert individually or (worse yet)
querying for an existing record before each insert. Suggestions?
R.