How to extract Indexed record set from a database

Laurie Comerford

unread,

Mar 25, 2005, 12:35:36 AM3/25/05

to

Hi,

While extracting a record set from a database with an SQL query, I
understand it is possible to get an indexed record set which enables an item
to be selected from the set without having to search through the records to
find it.

I can't seem to find any sample code for doing this.

Can I be pointed to some code or a simple explanation of the methods needed.

--

Laurie Comerford
CADApps
www.cadapps.com.au

Laurie Comerford

unread,

Mar 25, 2005, 5:43:24 PM3/25/05

to

Hi Scott,

Due to writing my first code with DAO and working on the principle it is
easy to write code with "Control C/Control V" I have never moved to ADO. Do
I need to for this exercise? I have seen references to the "Find method" in
the documentation and this is what I want to do. I have numerous
applications in mind, but the current one involves a flat table with about
1100 records in 60 fields stored in Access 97 format.

--

Laurie Comerford
CADApps
www.cadapps.com.au

"LochDhu" <@> wrote in message news:42440f84$1_1@newsprd01...
> Laurie,
>
> I assume we're talking ADO? You can index a Client Side cursor only by
> setting the property "Optimize".
>
> adors.fields(0).properties("Optimize") = True
>
> Keep in mind that not all providers support this. This is only suggested
on
> very large recordsets.
>
> Are you aware of the adors.Find method?
>
> Scott
>
>
> "Laurie Comerford" <lau...@DeleteThiscadapps.com.au> wrote in message
> news:4243a1ec_1@newsprd01...

LochDhu

unread,

Mar 26, 2005, 4:57:21 PM3/26/05

to

Laurie,

I haven't used DAO in years, so I don't know what the limitations are. But
if you are going to be writing database applicatons - and beginning new
applications, I would strongly suggest moving to ADO. ADO can easily handle
the data you are mentioning. There are numerous sites with sample code too.
If you need more help just ask.

Scott

"Laurie Comerford" <lau...@DeleteThiscadapps.com.au> wrote in message

news:424492cf_1@newsprd01...

Laurie Comerford

unread,

Mar 27, 2005, 4:02:48 PM3/27/05

to

Hi Scott,

"If you need more help just ask."

Yes, I can easily use ADO, so I'm back to my original question

While extracting a record set from a database with an SQL query, I
understand it is possible to get an indexed record set which enables an item
to be selected from the set without having to search through the records to
find it.

I can't seem to find any sample code for doing this.

Can I be pointed to some code or a simple explanation of the methods needed.

Add to that, if you could give me a guide lines to a web site where I might
look. The results of Google searches are so vast and the ones I tried
didn't actually have code.

Laurie Comerford
CADApps
www.cadapps.com.au
<snip>

LochDhu

unread,

Mar 27, 2005, 7:57:18 PM3/27/05

to

Laurie,

Here are a few links:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthfindmethodado.asp

At the bottom is a VB example using the .Find method.

http://authors.aspalliance.com/aspxtreme/ado/lettinguserssearchforinformation.aspx?pageno=4

aspalliance is a great site. Although it's asp-based the code is the same
for working with ADO.

For help with ADO connection strings look here:
http://www.ConnectionStrings.com

or,

http://www.able-consulting.com/ADO_Conn.htm

Hope that helps,

Scott

"Laurie Comerford" <lau...@DeleteThiscadapps.com.au> wrote in message

news:42471e35_1@newsprd01...

Laurie Comerford

unread,

Mar 28, 2005, 6:45:59 AM3/28/05

to

Hi Scott,

The Microsoft site gave me all I've been looking for. I feel quite a twit
as I couldn't locate the site with my searching.

Thank you for your help.

--

Laurie Comerford
CADApps
www.cadapps.com.au

"LochDhu" <NoSpam> wrote in message news:4247566e_3@newsprd01...