Can you please help me to implement a trigger using Delphi 7 and MS SQL 2005?
Please give me an example of how the set one up and then also how to receive the trigger in Delphi?
okay then the answer is a resounding... not really possible. IB has very close ties with Delphi, you can subscribe to events that will callback delphi code. SQL Server 2005 is a different kettle of fish. i don't believe you can hook to listen to those events per se- without using .NET code.
umm.. you want the SQL Server 2005 server to use code in a Delphi 7 dll in a trigger ?
0
Marius0188Author Commented:
Exactly like you would use Interbase Triggers and Stored Procedures.
I would like SQL database engine to notify my Delphi application of certain events for example: On New Record Inserted etc....
In my Delphi Application I can then respond to such notifications.
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I have to agree with above: you cannot receive a trigger event outside of sql server, unless you implement something complex like having a clr procedure that could push an event into all subscribed clients to a server component...
never done that, though...
0
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.