Recordset.find method too slow

[rkbnair]

Listen to my requirement please.

I have a list of 10 values. I have to process a table and get the description
of these 10 values from the table. What I did was, created a record set and
used a find method to find the data.
But this process took long time since after each find, I have to move the
cursor point to the first using "

rstexpressd.MoveFirst

Is there any short cuts for this which will reduce the time of processing?

[Daniel Reber]

If you already know the 10 values that you need why don't you return a
recordset based only on those values.
For example:
SELECT * FROM mytable WHERE myid IN(vaule1,value2,value3......)

Daniel Reber, MCP

rkbnair <rkannale@solus1.oceaneering.com> wrote in message
news:391c7be6$1@news.devx.com...
>
> Listen to my requirement please.
>
> I have a list of 10 values. I have to process a table and get the
description
> of these 10 values from the table. What I did was, created a record set
and
> used a find method to find the data.
> But this process took long time since after each find, I have to move the
> cursor point to the first using "
>
> rstexpressd.MoveFirst
>
> Is there any short cuts for this which will reduce the time of processing?
>
>