Position record at a specific position

From: Paulo (Paulo_at_discussions.microsoft.com)
Date: 08/11/04 

Date: Wed, 11 Aug 2004 09:37:04 -0700

Hi,

I'm having a little trouble here. I'm using VC++ and ODBC API.
The thing is i want to search an entire recordset for a given value in a
specific column, but i don't want to query the database since i want to
maintain the recordset as it is, so i can have the whole recordset still
available.

Right now i'm iterating through all records and test if there's a match.
As you can imagine in large databases this takes ages.

Is there a fast way to get the record i want (using another query) and then
position the original recordset in the same record, using some kind of
mechanism and using data from the other query like a Row Id?

Thanks for you help.

Relevant Pages

  • Re: HELP PLEASE: Populate certain userform fields from access database
    ... Opening a database you don't need to open a file like opening an excel ... This includes a SQL (Script Query Language). ... Move the Recordset data to the workbook. ...
    (microsoft.public.excel.programming)
  • Re: HELP PLEASE: Populate certain userform fields from access data
    ... Subjects to auto populate,, and all this details are in access database. ... '2) Open a recordset which is a set of instructions of what data you ... This includes a SQL (Script Query Language). ...
    (microsoft.public.excel.programming)
  • Re: Populating a Pull-Down
    ... you are also forcing ADO to make a second trip to the database ... Why open a less-efficient static cursor? ... I'm surprised you are not getting an error from "User Query". ... This line is not necessary, and in fact, may cause the recordset to be ...
    (microsoft.public.scripting.vbscript)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... Tools - references - tick Microsoft Outlook object library. ... in the criteria cell in the graphical query builder. ... the same filtered recordset every time. ... normal form to allow the normal filtering process and viewing of the ...
    (microsoft.public.access.formscoding)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... in the criteria cell in the graphical query builder. ... use as the source in the routine. ... the same filtered recordset every time. ... normal form to allow the normal filtering process and viewing of the ...
    (microsoft.public.access.formscoding)
Loading