Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
referring to Old Record in SQL?? |
Mon, Jul 30 2007 6:54 AM | Permanent Link |
"Ian Branch" | Hi Guys,
I am trying to create an After Deleted Trigger that will copy the old record into another database. e.g. When a record is deleted from Database A, it is automatically inserted into Database B. Something like the following.. INSERT INTO B SELECT * FROM B__Old; Any thoughts/suggestions? Regards & TIA, Ian -- |
Mon, Jul 30 2007 7:37 AM | Permanent Link |
"Robert" | "Ian Branch" <branch@sitathome.net> wrote in message news:9C410F80-E3CF-4854-BB21-87D158924594@news.elevatesoft.com... > Hi Guys, > > I am trying to create an After Deleted Trigger BeforeDelete. After delete it is gone. Robert |
Thu, Aug 2 2007 7:35 AM | Permanent Link |
"Ian Branch" | Robert wrote:
> > BeforeDelete. After delete it is gone. > So the INSERT syntax is correct? |
This web page was last updated on Tuesday, May 7, 2024 at 02:40 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |