Re: BIG BUG in Deleting detali records


You have to delete the detail records just deleting the master record
doesn't
delete detail records. You could write a trigger on the master table to
do
this for you.
i dont use trigger !

In addition if you have your master detail relationship set up to use a
parameter in the SQL statement when you change master records the detail
records
will be refreshed.
i dont use parameter !

If you have deleted detail records and have not called
updatebatch before changing master records all the deletes will be lost.

I think the updatebatch work wrong on deleting datil records ... IS A BUG of
adodataset and updatebath mode !

see post : 'deleting detail record' of 10/04/2007 - 23.04

BYE


--
Soluzioni Software di Gestione Aziendale
www.OnAzienda.it
"Brian Bushay TeamB" <BBushay@xxxxxxxxx> ha scritto nel messaggio
news:rm1253tcgm1nocjld6bruhjjq3p318uifj@xxxxxxxxxx

D2006+ADODataSet+SQLServer

In a master detail relation with transaction and batchoptimistic control,
happen deleting master record does not delete detail records after
updatebatch ...

This error was solved ?
You have to delete the detail records just deleting the master record
doesn't
delete detail records. You could write a trigger on the master table to
do
this for you.
In addition if you have your master detail relationship set up to use a
parameter in the SQL statement when you change master records the detail
records
will be refreshed. If you have deleted detail records and have not called
updatebatch before changing master records all the deletes will be lost.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx


.

Relevant Pages