Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
ServerEngineSQLTrigger event |
Wed, Jul 3 2013 7:24 PM | Permanent Link |
Adam H. | Hi Tim,
Thanks for implementing this event in the engine for us. I was just having a play with it today, and I was just wondering if you could please confirm my findings: From what I can gather at present, it only executes when a TDBISAMQuery component is used. If a user uses a TDBISAMTable component to edit a record, this event doesn't appear to be firing. Is this correct, and if so - would it be difficult to implement trapping SQL script that TDBISAMTables also use? Thanks & Regards Adam. |
Mon, Jul 8 2013 3:08 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Adam,
<< Is this correct, and if so - would it be difficult to implement trapping SQL script that TDBISAMTables also use? >> TDBISAMTable never uses SQL, so it won't fire the event. If you're referring to data definition functionality - the only way to get that to fire the SQL trigger is to use the SQL version of it instead of the CreateTable, AlterTable, etc. methods of the TDBISAMTable component. Tim Young Elevate Software www.elevatesoft.com |
Mon, Jul 8 2013 7:00 PM | Permanent Link |
Adam H. | Hi Tim,
> Adam, > > << Is this correct, and if so - would it be difficult to implement > trapping SQL script that TDBISAMTables also use? >> > > TDBISAMTable never uses SQL, so it won't fire the event. > > If you're referring to data definition functionality - the only way to > get that to fire the SQL trigger is to use the SQL version of it instead > of the CreateTable, AlterTable, etc. methods of the TDBISAMTable component. Aaah - Ok - that would be why then. Sorry - I misunderstood. I thought with the C/S version that the table component sent SQL commands to update records, but I thought wrong. (Wouldn't be the first time, and won't be the last ) Have a great day! Adam. |
This web page was last updated on Thursday, March 28, 2024 at 06:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |