Bill, Where do you store the triggers? Myron Finegold
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bill Downall Sent: Tuesday, November 19, 2002 10:30 AM To: [EMAIL PROTECTED] Subject: Re: Can that be done? Herb, Assuming that you have a unique linking column between A and B, this sounds like a perfect application of a trigger. Is there a one-to-one correspondence between the two tables, or a one-to-many correspondence. Are rows being added, deleted, and updated in A, and in each case, what should happen to tableB.invdate? Are you loading new rows in tableB, or just updating a date in tableB? If tableA.invdate be changed to a null? If so what would happen to tableB.invdate? Give a few more details so we can help you set up an update trigger, and maybe an insert trigger and delete trigger. Bill On Tue, 19 Nov 2002 10:08:47 -0500, Herbert Hemberger wrote: >I have two tables in the same Db. Lets call them -A- and -B- >And a column in each Table called "InvDate". >The data is only in Table -A- and I would like to populate the column >"InvDate" in Table -B- with the data permanently and update it as >necessary. >Could that be done? And if "Yes" how? >Thanks for any advise and help >Herb ================================================ 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/
