Solved

Delphi 7 :: MS SQL 2005 :: Triggers

Posted on 2007-11-18
4
376 Views
Last Modified: 2013-11-23
Hi Experts,

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?

Thanks in advance!
0
Comment
Question by:Marius0188
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 25

Expert Comment

by:imitchie
ID: 20310819
umm.. you want the SQL Server 2005 server to use code in a Delphi 7 dll in a trigger ?
0
 

Author Comment

by:Marius0188
ID: 20310839
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.

Is this more clear?


Thanks :)
0
 
LVL 25

Accepted Solution

by:
imitchie earned 500 total points
ID: 20310861
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.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 20310894
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

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question