Chris,

I saw a very complete answer to your issues earlier. Did you see it?

If so, please revise your question so that people aren't going to duplicate
the efforts to respond to it.

Thanks,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Chris Landowski" <chrisl@...>
To: <IBObjects@...>
Sent: Tuesday, January 02, 2001 8:18 AM
Subject: [IBO] Please Help !!!


> I have been struggling for the past couple of months attempting to convert
an existing BDE/Paradox based app over to IBO/InterBase, and have run into a
major road block that hopefully someone can shed some light on.
>
> The app I am converting has roughly 250 tables and well over 1000
datasets. The average database size is roughly 2GB and the average number of
records per table is roughly 200,000. It's a fairly large scale app that
could really benefit having IB as a back end.
>
> My problem is this, Almost every major form in the app contains shortcut
keys and toolbar buttons for first, previous, next and last record (Similar
to a navigator control). The user also has the ability to jump directly to a
record based on an entered key field value.
>
> Using the BDE & Paradox with TTable components, this feature was fairly
easy to implement, consumed very little memory and was lightning fast. Using
IBO & InterBase I cannot seem to achieve the same effect.
>
> I am assuming that a scrollable dataset is required for these features, so
I use a TIBOQuery. However performing a Last or Locate ends up buffering the
key data for the entire table. The tables are fairly large and this process
end up exhausting all the clients memory and causes an enormous amount of
network traffic.
>
> Please tell me there is some way to scroll around a dataset without having
to buffer all the key data in the clients memory ? My users will have a fit
if these features are taken away and will most likely reject the upgrade in
favor of the old BDE/Paradox version.
>
> Also, is there any way in IB to create a case insensitive index like in
the BDE ?
>
> Your help would be greatly appreciated,
>
> Chris Landowski
> Dynamic Software Solutions