🚀 go-pugleaf

Make master/details relashionship manually - load master dataset, handle
AfterScroll event and in this event close and open details dataset (query
for details dataset is usually the same as for master with additional WHERE
...).

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Bonny Rais" <bonnyr@optushome.com.au> �������/�������� � ��������
���������: news:3e704aed@newsgroups.borland.com...
> All,
>
> I've posted a question regarding the time it takes to start up an
> application
> with an active dataset of medium size (70K records). It was suggested that
> this happens because the cursor location is on the client which forces the
> loading of the complete dataset in order to facilitate sorting/filtering.
> However, I've changed the cursor location to be server side and now
> I'm getting exceptions with a dataset which is related to the above
dataset
> and which is used to show the details in a master/detail form. I cannot
set
> the cursor type to dynamic/static/keyset (at least this is what the ODBC
> driver states) and
> it is required to be such for bookmarks to work...
>
> what gives?
>
> I am new to C++ builder so I'm not sure what the best way to achive this
is,
> but I'm sure many people have done this before: the scenario is a
> master/detail
> combination with ~100K master records and ~500k detail records. What's
> the best way to have a responsive UI without loading the complete master
> table
> into memory?
>
> Cheers,
>
> Bonny
>
>
>