Hi Steve,

> 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?

No, there isn't.

> 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. :-<)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com