Re: TADODataSet using outer joins and delete method !!!

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 10/11/04

  • Next message: Viatcheslav V. Vassiliev: "Re: Accessing A Large MS SQL Table Over ADO Components" 
    Date: Sun, 10 Oct 2004 20:31:47 -0500

    >While testing I assigned a query assigned to TADODataSet using outer joins.
    >If I delete the record using TADODataSet.Delete method, the outer joined
    >records also deleted. Is

    Ado has a Unique Table property you can set to do this.

    You should put this code in the BeforeDelete event
    begin
      ADODataSet.Properties['Unique Table'].Value:='Name of a table';
    end; 

    --
Brian Bushay (TeamB)
Bbushay@NMPLS.com
  • Next message: Viatcheslav V. Vassiliev: "Re: Accessing A Large MS SQL Table Over ADO Components"

    Relevant Pages

    • Re: How to get the previous value of a field
      ... Ado doesn't keep that information after Post unless you setLockType to ... Brian Bushay (TeamB) ...
      (borland.public.delphi.database.ado)
    • Re: ado and delphi8
      ... >where can i find a sample showing how to use delphi 8 and ado ... Brian Bushay (TeamB) ... Prev by Date: ...
      (borland.public.delphi.database.ado)
    • Re: Updating GUID-field for ADO.NET in Delphi 2005
      ... Is the GUID-type field supported on ADO? ... Type AdGuid ... Brian Bushay (TeamB) ...
      (borland.public.delphi.database.ado)
    • Re: Query 200 Records?
      ... >Delphi 7, ADO, MS-SQL Database. ... Brian Bushay (TeamB) ...
      (borland.public.delphi.database.ado)
    • Re: ADO connection
      ... That is not something you can detect with ADO or SQL server ... Brian Bushay (TeamB) ...
      (borland.public.delphi.database.ado)