Re: ADO is a BUG

"Cavalera Guido" <cavaleraguido@xxxxxxxxxxxx> wrote in message
news:4654582f@xxxxxxxxxxxxxxxxxxxxxxxxx
The BIG is : SQLExpress+ADODataset+BatchOptimistic+MasterDetail

If i delete a master and details record and then i do ApplyUpdates to a
Master and Detail datasets, the details records don't deleted from the
databse... if u want i can pass u a simple code to see this ... give me
your eMail...

This is a BIG BIG BUG really !

BYE


I don't think Microsoft's ADO implementation of BatchOptimistic was designed
to work the way you are trying to use it.

IMO, the best option is to handle referential integrity through foreign keys
and/or triggers. When the master record is deleted, let the server, not the
client (your application), do the work. That way when, not if, a 'master'
inherits more 'children', all you have to do is modify server side code.

If that is not an option, then using TClientDataSets is the next best thing.
That way, you can use ADO, SQLExpress, or whatever against almost any RDBMS
(MSSQL, Interbase, Oracle, etc).

Good luck,
krf


.