Hi Greg. Have you tried using a ClientDataSet? If you're not familiar
with them then I recommend looking at the Demos/MIDAS/Aggregate project
as an initial training session. The PacketRecords property enables
navigating exactly as you describe (records are supplied on demand, you
dictate the rate).
Cheers,
Carl Reynolds Ph: +64-9-4154790
CJN Technologies Ltd. Fax: +64-9-4154791
[EMAIL PROTECTED] DDI: +64-9-4154795
PO Box 302-278, North Harbour, Auckland, New Zealand
12 Piermark Drive, North Harbour Estate, Auckland, NZ
Visit our website at http://www.cjntech.co.nz/
>From: Greg Nixon [SMTP:[EMAIL PROTECTED]]
>
>I was just wondering how some of you copy with large datasets eg. A
Client
>entry srceen. If you open the query selecting all you can go on holiday
and
>forget it. So the way I normally handle if is selecting the dataset
where
>1=0 (imposible) and then allow them to make selection according to
there
>needs. This works fine but I was wondering if any one had a nicer way.
It
>would be cool if the BDE would pass the live query to the server and
just
>get the first record and then if you clicked next on the navigator get
the
>next record, and so on, rather than taking the whole dataset at once.
>
>Also anyone got any tips for DBgrids and large datasets. We have one
screen
>where you enter bank interest on mortgages and there can be upward of
two
>hundred entries and as you can imagine it takes for ever to move or
delete a
>row.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
