ADOXtra: find record

[James G webforumsuser@macromedia.com]

Does anyone know a good way to find a particular record in a recordset? I was hoping there would be something like rst.Seek(), but there isn't.

The scenario is that I want users to be able to move backwards and forwards through a recordset, but I don't want to hold the connection open all the time. So I need to be able to get back to the right record each time the connection is reestablished.

[Eugene Shoustrov]

ADOxtra uses Recordset interface definition of version 2.0. It does not
contain Seek or Find methods. They were added in later versions.

You may use VbScriptXtra that does not rely on any specific version and
allows you to use whatever installed, including Seek or find methods of
ADODB.Recordset.

--
Best regards,
Eugene Shoustrov
[url]www.xtramania.com[/url]


"James G" <webforumsuser@macromedia.com> wrote in message
news:bgmspo$9f2$1@forums.macromedia.com...
Does anyone know a good way to find a particular record in a recordset? I
was hoping there would be something like rst.Seek(), but there isn't.

The scenario is that I want users to be able to move backwards and forwards
through a recordset, but I don't want to hold the connection open all the
time. So I need to be able to get back to the right record each time the
connection is reestablished.