Re: OTHER BIG BUG : deleting detail master delete

This is "as designed" by Microsoft and not a bug.

Goooooooood very good ! Excuse me, if i dont have a relation on the database
and i want to delete 'simple' a detail record in a table, ADO delete all
!!!!!!!!$%$&%$/&%$ bill gates, M$, ADO, are very crazy ! IS NOT POSSIBLE
THIS ! ADO create a damage dont protect data integration !

Try
I thank u very much for your suggestions
Except
Del Murrey.... i joke but u dont know me and my problems to say this
things ...
End

Bye

--
Soluzioni Software di Gestione Aziendale
www.OnAzienda.it
"Kevin Frevert" <kevin@xxxxxxxxxxxxxxxxxxxxxxxx> ha scritto nel messaggio
news:4656d38f$1@xxxxxxxxxxxxxxxxxxxxxxxxx

"Cavalera Guido" <cavaleraguido@xxxxxxxxxxxx> wrote in message
news:46567b2a@xxxxxxxxxxxxxxxxxxxxxxxxx
D2006+ADODataSet+SQLServer

In a master detail relation with transaction and batchoptimistic control,
happen that if i delete a detail record then in UpdateBatch also master
record is deleted from database table but not in a dataset !!!!

If you have a reference to the master table in the detail query, ADO tries
to be really smart and assume you want all related data in each joined
table deleted. This is "as designed" by Microsoft and not a bug.

Again, IMO, the best long term solution is to put the work on the server
(cascade delete trigger), not the client. If the target database is
unknown (could be MSSQL, Oracle, etc) and/or the DBA won't let you in
100ft of the server, use TClientDataSet<->TDataSetProvider<->TADODataSet.
You have complete control over what SQL scripts are generated and
compatible with nearly all RDBMSs.

Good luck,
krf




.

Relevant Pages

  • Re: OTHER BIG BUG : deleting detail master delete
    ... database and i want to delete 'simple' a detail record in a table, ADO ... In a master detail relation with transaction and batchoptimistic ...
    (borland.public.delphi.database.ado)
  • Re: ANN: Special kbmMW timelimited offer!
    ... On each master change, get a new matching detail record from the database. ... > What about Master-Detail support? ...
    (borland.public.delphi.thirdpartytools.general)
  • data and display out of sync
    ... displays a master record. ... Since the detail record will most likely contain some data that's ... database is concerned - the record is there exactly as it should be. ... However on the page control, all copied entries only make a very brief ...
    (borland.public.delphi.database.ado)
  • line in detail
    ... I created a report using wizard and each detail record has a line underneath ... When I open the report in design view, I dont see this line in the detail ...
    (microsoft.public.access.reports)