Hi All,

I'm writing a process to syncronize a Paradox table's integer field
with that of a Firebird table (Paradox the source and Firebird the
target). I'm using explicit transactions.

1. The process first uses a store procedure (TIB_DSQL) to increment
and Firebird integer field by 10000 to avoid duplicates during the update.

2. I then use a TIB_Query to locate a record by a Paradox string field
and update the Firebird integer field to match the Paradox integer field.

3. I then use a TIB_Query to try to resolve any of the records that
might not have been matched via the integer value by using a string
field to locate records. During this process, I'm getting an
exception because the previous updates (item 2 above) aren't there.
All of this is happening within the explicit transaction.

Is there a problem with openning and closing query objects within a
transaction? I can trace this process in the debugger and see that
the updates are being made during item 2, but in item 3 they don't
appear to be there.

Any ideas?
Steve