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


[Non-text portions of this message have been removed]