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

Jason

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