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 !
Since AdoDataset is just calling methods in Microsoft ADO it certainly is not a
bug in AdoDataset



see post : 'deleting detail record' of 10/04/2007 - 23.04
Your posts don't make much sense so I can't see going over this again.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Trigger, alternative way to pass variable to trigger
    ... Assumed that I have SP_SETUSER 'myuser_ID' in the MASTER ... >Then in the trigger or default constraints, ... >system function, though just calling it as master.. ... >>>Pro SQL Server 2000 Database Design ...
    (microsoft.public.sqlserver.programming)
  • Re: Print Form/Report with Master and one Detail record per page?
    ... For the purpose the forms were designed for, the subform ... worked correctly showing all detail records for any master ... I did not have a query ...
    (microsoft.public.access.formscoding)
  • Re: Print Form/Report with Master and one Detail record per page?
    ... on one sheet even in the case of many detail records. ... Primarykey to allow a detail record to be uniquely ... along with the corresponding master ... SQL INNER JOIN the needed SQL clause to select all ...
    (microsoft.public.access.formscoding)
  • Re: BIG BUG in Deleting detali records
    ... You could write a trigger on the master table to ... I think the updatebatch work wrong on deleting datil records ... ... happen deleting master record does not delete detail records after ...
    (borland.public.delphi.database.ado)
  • Re: Identity error?? Please help
    ... I do know that in SQL Server, if you get the value of an IDENTITY column in ... a trigger, depending upon which global variable you look at, you will always ... In the afterpost event of the adoquery i want to get the newly ... > Datasource property of the detail query) AND I have trigger on the master ...
    (borland.public.delphi.database.ado)