Randy, Thank you for the suggestion. Take a look at Razzaks reply, this clears up any question I had.
Richard (Ringo) Starkey -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of randyp Sent: Monday, June 10, 2002 11:59 AM To: [EMAIL PROTECTED] Subject: Re: Insert Trigger question! Richard, Copy your database. In the copy, pick a data set with this missing last name as an element. (Maybe use 5 records, with 2 or 3 having a missing last name). Run your program and SEE what happens to the the actual data. In other words, test data having that characteristic and see what happens. Take care and good luck. Randy Richard Starkey wrote: > Hello All, > > I have a table called Person with the PK key of PersonNo which is an > autonumber column and various other columns, a table called Company with the > PK of CompanyNo which is also an autonumber column and various other columns > and a table called PerCoNo (Person Company Number) with the following > columns PerCoNo is PK and autonumbered, PersonNo, CompanyNo. > > When I insert either to the Person table or the Company table an insert > trigger fires which selects the PK from the Person or Company table and > inserts it into the PerCoNo table which auto assigns a PerCoNo. > > There is a Not Null constraint on the LastName column in the Person table. > > My question is this: > > If I am processing data with a cursor while loop and an insert into the > Person table fails because there is no LastName will the trigger fire and > insert the PK value into the percono table? > > Thanks > Richard (Ringo) Starkey > > ================================================ > 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/
