With above question...
In my test, I got "unassigned code" error when detail dataset constitued of
We can't use TSQLQuery-DataSetProvider-ClientDataset as Detail Dataset ?
I'm very confused at this situation.
Firebird 1.5, D7
master-query : select * from member (total about 20,000 records)
detail-query : select * from order (total about 60,000 records)
master : SQLQuery1 - DataSetProvider1 - ClientDataset1 - DataSoruce1 -
detail : SQLQuery2 - DataSetProvider2 - ClientDataset2 - DataSoruce2 -
Set ClientDataset2's MasterSource property to 'DataSource1'
Set ClientDataset2's MasterField property to 'cust_no'
Set ClientDataset2's IndexFieldNames property to 'cust_no'
Set ClientDataset2's PacketRecords property to '0' (<- automatically changed
from -1 by Field Link Designer)
(All of them are set by Field Link Designer)
set ClientDataset1's Active to True....
set ClientDataset2's Active to True.... <----- "SQL server error :
unassigned code" error occur!!..
why? and how to....?
----- Original Message -----
From: "kmaku" < XXXX@XXXXX.COM >
Sent: Thursday, October 14, 2004 12:04 PM
Subject: how to improve speed of fetching record in Master-Detail