>Hello,
>
>I am a VFP Programmer and have worked in 5.0 and 6.0
>Now I am doing project in Vb 6.0 In that I want to findout
>a particular record by using recordset.find function.
>It works with one field perfectly.
>But, problem arises that I want to find out a record by
>checking a track of two or it can be more than two fields
>also. At this time recordset.find gives an error like
>"Recordset conflict or Two long data type" etc . . .
>So, how can I find out a particular record by checking a
>track on more than one fields.
>Also, I am using an ADO technology and I am giving a
>command like following and I have created an Indexes also on
>those fields which I want to search.
>
>recordset.find "fieldname=" & "'" & & "'" _
> & " + fieldname=" & "'" & & "'"
>
>I know it is not possible but is there any other method to
>find out the records so that I can proceed further.
>
>Thanx in Advance,
>Amol
Sorry Amol, but it's not possible. The Find method only supports single criteria searches. If you want to search by multiple criteria you'll have to do another query.
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
