> Myles
>
> If ADO Supports this (if only for MS SQL and Access) is this
> part of the ADO Provider Spec (ie could other OLE DB
> Providers support this)
>
Yes, no reason why not - but don't know if the OLE-DB spec has anything
about this.
The problem really only occurs when attempt to a master/detail insert at the
same time, where the detail has to know the primary key of it's master. -
It's a right pain to have to handle this as a special case (using SP's etc
to solve).
The other part of the problem is with TDataSet, in that there is no support
for "data" changing when/after/as a record is inserted.
MIDAS does have some support for this with poPropagateChanges. Maybe the BDE
did have some support as you need to change the value in the record buffer
without telling the TDataSet about it.
TADODatasets may also get around the problem, as the TDataset reads all the
data as variants from ADO, so it ADO updated its resultset buffer then
things would be okay.
Have not tried a master/detail insert via ADO.
Myles.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
