Re: BIG BUG in Deleting detali records


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

  • Re: About "caching" Re: Ajax Demo
    ... in the first time. ... each master record has about 10 detail records. ... no matter what the data model volumetics ...
    (borland.public.delphi.non-technical)
  • Retrieving Contents of Select List on Form Submit
    ... On an HTML form, I have a select list that is fed dynamically with ... detail records when the master record is displayed on the form. ... array so I can update and add the proper database records. ...
    (comp.lang.php)
  • Print Form/Report with Master and one Detail record per page?
    ... many detail records for each master record. ... page when there are multiple detail records. ... I tried using a report, ...
    (microsoft.public.access.formscoding)
  • Re: deleting detail record
    ... In a master detail relation with transaction and batchoptimistic control, ... happen deleting master record does not delete detail records after ... updatebatch ... ... application so that it deletes detail records before allowing the master to be ...
    (borland.public.delphi.database.ado)
  • RE: How to diable edit mode in the datagrid
    ... Protected Function CheckStatus(ByVal StatusID As Boolean) As Boolean ... > I have a datagrid that allows users to eidt/update detail records. ... > shows detail records for a master record. ...
    (microsoft.public.dotnet.framework.aspnet)