🚀 go-pugleaf

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