Hi Guys,

I think I know the answer to this one but I'll ask anyway. Is there a
way to turn off referential integrity within a transaction so that you
can make sweeping changes that may temporarily voilate referential
integrity?

I have a Paradox table that I need to sync with a table in the
Firebird database using unique ID fields. The tables contain fields,
Name and ItemCode that are unique in both tables but may not point to
the same IDs. I'd like to sweep through the Paradox table and update
each record (based on it's ID) in the Firebird table so that the ID,
Name, and ItemCode fields all match in both tables.

Thanks for any advise, (Other than ditching Paradox. That's not
possible. :-<)

Steve