Delete records

From: Josep (jsola_at_ipssoft.com)
Date: 12/27/04

  • Next message: JamieSuk: "Re: Set Zero when field is Null Value." 
    Date: Mon, 27 Dec 2004 14:02:52 +0100

    Hello,

    I have made a form with a master detail TAdoQuery's. When I try to delete a
    record from de detail TAdoQuery, calling Delete method. That raise an error.
    I'm using SQL SERVER and I have looked, with SQL analyzer, that ADO sends
    two sql sentences, a first one to delete the record from master and a second
    one to delete detail. This second one raise the error.

    Any Idea?

    Thanks and Happy new year!!!

    Josep Solà

  • Next message: JamieSuk: "Re: Set Zero when field is Null Value."

    Relevant Pages

    • Re: ADO Multiple-step operation generated errors
      ... the data is to wide error but instead it raise multi step errors, ... > This exception is raised only from the IDE in runtime, ... A dblclick on the table name in the listbox ... >> on the fly or just us the default SQL to obtain all the records. ...
      (borland.public.delphi.database.ado)
    • Re: Job XXX started successfully.
      ... This message is informational and shouldn't raise an exception in your code. ... SQL Server MVP ... The stored procedure simply call the MS SQL system procedure ...
      (microsoft.public.sqlserver.programming)
    • passing SQL error to D7
      ... I have a trigger in MS SQL 2000 where I raise an error if a field cannot be ... In my ADO Dataset OnDeleteError code a really grungy message pops ...
      (borland.public.delphi.database.ado)
    • Re: Delphi handling of SQL server generated errors
      ... Delphi should raise an Exception whenever a client ... >app that is connected to an SQL Server runs an SQL statment that ... whenever SQL Server rasies an error using the ...
      (comp.lang.pascal.delphi.misc)