🚀 go-pugleaf

Dear Ivan,

    Your information is very helpful, I've resolved my problem, Thank you
very much.

Junlin Xie
"Ivan Mihailov" <iradev@mail.vega.bg> wrote in message
news:3c9a4bba_2@dnews...
> Hi,
> Check this link and you will find  the answer of your question
>
> http://www.microsoft.com/mspress/books/sampchap/3445.asp
>
> Ivan
>
> "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
> >
> >
>
>