Help! - ADO navigation...

[Dodger]

Hey All,

I don't appear to have the seek function, maybe that's just for DAO, but what I need to do is:

Search for a field which contains a specific value and position the cursor accordingly.

My datasource is a data-aware class, which is populated from a delimited text-file. I uses the append methods to add fields to a recordset.

Any idea on how I can accomplish this would be greatly appreciated.

TIA.

[mendhak]

you can use

objrs.find "fieldname = criteria"

Is this what you wanted?

[Dodger]

Oh, now I remember the problem, it's not possible to have a variable value for the criteria, right?

What do I do?

[mendhak]

I don't wish to say "you're welcome"!!!

OK NOW I DO!

You're welcome

[tr0n]

Originally posted by Dodger
Oh, now I remember the problem, it's not possible to have a variable value for the criteria, right?

What do I do?

yep

rs.Find "Field1 = '" & strMyString  & "'"

[Dodger]

THANKS!

[Dodger]

Oh, one more question.

Is it possible to use the find function with multiple criteria?

[tr0n]

indeed

rs.Find "Field1 = 'blah' AND Field2 = 'snuh'"

[tr0n]

oops, just looked that up on MSDN (wasn't too sure about it), and apparetly you can't. i'm sure i've done it though...

[Dodger]

Could you tell me how you did it?

[tr0n]

well, i thought i did it like in the last example i posted, but then i looked at this on MSDN:

Find Method
The ActiveX Data Objects (ADO) version of the Find Method supports only singular column searches. As a result, using the "And" or "Or" keywords to append criteria will not work.

Creating a new recordset will frequently provide better performance and does not limit you to single column filters.

but that's confused me. first they say the Find method only supports singular column searches, then in the next sentence, they say it supports multiple searches!

try using the code i just posted anyway

[Dodger]

I tried this and it didn't work:

dataContacts.Find "fName = '" & fldVal(0) & "' AND lName = '" & fldVal2(1) & "'"

[tr0n]

the only thing i can suggest is to see what version of ADO you're using. other than that i'm not sure.

[Dodger]

ADO 2.1

[tr0n]

yeah, that's what i have referenced in my project... i'm sure it's possible somehow, but seeing as i don't have VB6 on this PC i can't try anything. sorry.

[Dodger]

Thanks Anyway.

[Kevin Swanson]

You can use .Filter with multiple criteria, but not .Find.