Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread ServerEngineSQLTrigger event
Wed, Jul 3 2013 7:24 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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. Smile

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 PMPermanent 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. Smile
>
> 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. SmileSorry - 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 Smile)

Have a great day!

Adam.

Image