Subject Re: [firebird-support] Referential Integrity
Author Jason Dodson
You don't want to do that. Sure, it SEEMS simplier, but it is the wrong
way to do it.

Take the time and store things accordingly


Steve Harp wrote:
> 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