master detail with ADO recordsets
- From: praveen jalem <praveenjalem@xxxxxxxxx>
- Date: Tue, 24 Jan 2006 18:49:59 +0530
Hi,
I have imported the "Microsoft ActiveX Data Objects 2.8 Library" TLB into Delphi VCL components.
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??
Thanx, Praveen. .
- Follow-Ups:
- Re: master detail with ADO recordsets
- From: Brian Bushay TeamB
- Re: master detail with ADO recordsets
- Prev by Date: Re: UPDATE SQL for Excel - very slow - any suggestions?
- Next by Date: Re: Programtically drop a constraint ??
- Previous by thread: Integer array as BLOB
- Next by thread: Re: master detail with ADO recordsets
- Index(es):