ClientDataSet with SQL Server Triggers

From: Mark A. Deal (nospam_at_idaknow.com)
Date: 06/22/04 

Date: Mon, 21 Jun 2004 20:07:34 -0400

I have triggers setup on my SQL Server database which handle cascading
deletes. I am using ClientDataSets in my D7E application and when I attempt
to delete a record I get an error back from the server explaining that it
cannot locate the records for deletion.

My assumption is that the TClientDataSet is handling the deletions properly
and then the SQL Server trigger fires and the records are no longer there to
delete.

Anybody know of a way around this quandary?

Assume that I have very little control over the triggers or, better yet,
would prefer to use the internal trigger-based RI provided by triggers.

Sure would appreciate any thoughts or advise. 

-- 
Mark A. Deal
Document & Data Solutions, LLC
http://www.docsol.com
Time Matters AIC
HotDocs Certified Consultant
GhostFill Certified Consultant

Relevant Pages

  • Re: New to SQL server
    ... it is called triggers. ... ANYTHING THAT YOU CAN DO IN JET IS BABY TALK COMPARED TO WHAT WE CAN DO ... anything that you can do in JET that I can't do in SQL Server ... self-referencing FKs and inline constraints. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: need information for "Before Select" Trigger
    ... As i've added "Enforced Constraints" ... There are no BEFORE SELECT triggers. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Encrypting SQL objects
    ... objects, i.e. Stored procs, Views, triggers. ... engine must be able to read the source code at run to be able to compile ... And if SQL Server has access to it, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server Express versus Access (In the World Series of Love)
    ... As far as the triggers are concerned, the first case is something to avoid ... have their usefulness, for updateability, but Jet has already updateability ... OF triggers to achieve the same, say, over view, so, advantage to Jet. ... MS SQL Server may have a horse shoe maker right out of the box, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Whats wrong with triggers?
    ... On the Microsoft SQL Server platform triggers offer an extremely powerful ... > (via a PC app) and writes it to a database. ... > processed using triggers and stored procs and replicated to a central ...
    (comp.databases)