COM Database VB6 question

[Ruslan Zasukhin]

on 2/22/04 5:28 PM, Lee Miller at leemiller at madisongrp.com wrote:

> I have a form that accesses one table.
> That table has 20 fields and 1,000,000 records. Five fields are indexed.
> There are navigational buttons at the bottom of the form to move First,
> Previous, Next, and Last.
> 
> I would like to provide the user with a combo box that contains the name of
> the 5 indexes. The one showing when the combo box is closed is the current
> index. When the user selects a different index from the combo box, the
> current record shouldn't change (if it must, I will recover it with code).
> When the user clicks on one of the navigational buttons, the new index
> [?new recordset] is reflected. I can handle the combo box. The fields on
> the form reflect the newly selected index path/
> 
> Do I need to set the old recordset to nothing and create a new recordset on
> the selected index [SQL SELECT] every time they do this or is there a more
> efficient way to "quickly' accomplish this?

You need re-create recordsset.
This is standard practice.

For example, image that you get recordset from remote server.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------