If it is a constraint on the table and not a rule, turning the rules off won't do anything for you. Rules can be turned off, constraints can not be turned off.
Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 10/18/02 12:59 pm >Two possible solutions. First turn rules temporarily off and try. Second, >backup data for both tables for the employee in question, delete data from >tables, edit backup file with new employee ID, reload. > >Javier Valencia, PE >President >Valencia Technology Group, L.L.C. >14315 S. Twilight Ln., Suite #14 >Olathe, KS 66062-4571 >(913)829-0888 >(913)649-2904 FAX > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]On >Behalf Of [EMAIL PROTECTED] >Sent: Friday, October 18, 2002 1:46 PM >To: [EMAIL PROTECTED] >Subject: Constraints > >I have an interesting issue - > >I have a table called 'employees' which has EMPID set as a primary key >I have another table called 'qualified_master' which has EMPID as a foreign >key that references 'employees' > >Well, since mistakes happen, an employee was entered with the wrong EMPID in >both the 'employees' table, and also had entries entered into the >'qualified_master' and 'qualified_details' tables. > >Because of the constraint, I cannot update the EMPID in either table! Is >there a way to change it I am not seeing, short of deleting the rows in the >'qualified_master' and 'qualified_detail' tables? That is my last resort >because there is a lot of data in those tables tied to this particular >employee. > >Thanks! >Charles Sikora >Coordinator, Gas Storage >Manlove Field >Peoples Energy Corporation > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
