[Emerald] Can you disable foreign key constraints? (then enable after you're done updating)

Andrew Stinson ( (no email) )
Wed, 22 Sep 1999 15:24:51 -0500

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Mourad Dahoumane: "Re: [Emerald] Violation of PRIMARY KEY constraint 'pk_RadLogs'. Cannot insert duplicate key in obje"
Next message: Dale E. Reed Jr.: "Re: [Emerald] Can you disable foreign key constraints? (then enable"

We're trying to correct a spelling mistake in the accounttypes table, but
can't update the table because of the Foreign Key constraints with
SubAccounts.Accounttype. How can I disable this long enough to update the
AccountTypes name, or can it be done? I went into the DB, AccountTypes
table, Design Table, Properties for the AccountType column, and removed the
check from Enable relationship for INSERT and UPDATE thinking that might
work (i did it for both tables)....Didn't work...if it's possible (or not)
let me know please.......thanks....
_____________________________________________________________________
Andrew Stinson
astinson@apex2000.net
Apex 2000 Internet Services Corporation Phone: (915) 570-1676

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart

Previous message: Mourad Dahoumane: "Re: [Emerald] Violation of PRIMARY KEY constraint 'pk_RadLogs'. Cannot insert duplicate key in obje"
Next message: Dale E. Reed Jr.: "Re: [Emerald] Can you disable foreign key constraints? (then enable"