Re: master detail with ADO recordsets


>Currently I create Queries in the following way.
>
>//connection creation
>FDBConn := ADODB_TLB.CoConnection.Create;
>FDBConn.Open(ConnString, 'SYSTEM', 'MANAGER', adConnectUnspecified);
>
>//query creation
>FQry := ADODB_TLB.CoRecordset.Create;
>FQry.CursorLocation := adUseClient;
>FQry.Open(SQLText, FDBConn, adOpenDynamic, adLockOptimistic, adCmdText);
>ADOQuery1.Recordset := AdoInt._Recordset(FQryMaster);
>
>Then I use ADOQuery1 for editing, inserting, etc.
>
>If I want to establish master-detail relationship between two
>ADOQueries, created in the above manner by assigning recordsets, how
>should I be doing??
I would write code in the AfterScroll event of the master dataset to update the
detail dataset.
It would be easier to just use TadoDataset components from the start and let
Delphi handle the master/Detail relationship.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.