🚀 go-pugleaf

I would use another SQL statement to achieve deletion.

DELETE FROM od WHERE od.ID = SomeID;

Lee Gan

"Junlin Xie" <jlxie@yahoo.com> wrote in message news:3c99721b_1@dnews...
> Hi,
>     I am using a TADODataSet to query data from SQL Server 7, there are 2
> table joined in SQL, like the following:
>
> select od.OrderID, od.OrderDate, Cust.CustCode, od.BuyerRef, od.Brand,
> od.ShippingMethod, od.ShipmentFrom, od.ShipmentTo, od.Consignee,
> od.PaymentTerm, od.CreditDays, od.PriceTerm, od.ReqDeLvDate,
od.ReqDateDes,
> od.RealDelvDate,  od.RealDateDes, od.DelvCountry, od.PriceUnit,
od.Quantity,
> od.Amount, od.TotalWeight, od.TotalSize, od.Confirmation, od.Approved,
> od.ApprovedBy, od.Status, od.OrderTypeID, od.DeptID  from Orders od left
> join  Customers Cust on Cust.CustID = od.CustID where (od.OrderDate
Between
> :StartDate and :EndDate) and (od.DeptID = :DeptID or od.CustID = :CustID)
>
>     When I delete a row from DataSet, I just want to delete the row in the
> first table(Orders), Using DataSet->Delete(), but It also delete the
second
> table( Customers ) row, What's wrong with me.
>
>     The following tracing message are from SQL Server Profiler after I
> execute the delete operation:
> sp_executesql N'DELETE FROM "CELDB".."Customers" WHERE "CustID"=@P1',
N'@P1
> varchar(12)', '2018        '
> go
> sp_executesql N'DELETE FROM "CELDB".."Orders" WHERE "OrderID"=@P1', N'@P1
> varchar(20)', 'PI02D03051          '
>
>     How can I delete only primary table row in a joined query?
>
>     by the way, I'm using BCB5 and SQL7.
>
> Thank you very much
>
> Junlin Xie
>
>