The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
Course Of The Month
2 days, left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Delphi 7 :: MS SQL 2005 :: Triggers
Posted on 2007-11-18
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!
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!
[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
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 :)
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 :)
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses
Course of the Month2 days, left to enroll
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.