Re: adSeek equivalent in SQL Server?

Thank you Val. But Find method supports only one column . I have a composite
key in which case i guess i have no option but to use Select Query. But i
what if i need to do Move in the record set. I think it would be more
expensive to open and close the record set everytime. Am i right?

"Val Mazur (MVP)" wrote:

> Hi,
>
> You could use Find method of the recordset, but best approach is to use
> SELECT with WHERE clause to select specific records rather than to open huge
> recordset and do a search inside of it. It could be too expensive from the
> resources point of view and could lock some records.
>
> --
> Val Mazur
> Microsoft MVP
>
> http://xport.mvps.org
>
>
>
> "Sarath" <Sarath@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:56A06D33-434F-4586-8609-F0B720FBC84E@xxxxxxxxxxxxxxxx
> > Is there an equivalent for Seek operation in a recordset in SQLOLEDB
> > provider? if not how can i seek a record from a record set with out
> > closing
> > it everytime.
> > thanks
> >
>
>
>
.

Relevant Pages

  • Re: Recordset gets corrupted
    ... "prash" wrote in message ... > is there any paramter that i have to set to get the record set unicode ... > "Val Mazur" wrote in message ... I think you need to install localizable copy of MDAC to work ...
    (microsoft.public.vb.database.ado)
  • Re: Return Value and Output Variable Always Zero
    ... When I try to explicitly close the record set, I get an error saying that it ... "Val Mazur " wrote: ... @testint as integer output ... declare @cnt as int ...
    (microsoft.public.vb.database.ado)