Searching with 2 different data types in ADO

[RADM]

Hi,

When I tried to seach a table with condition combined both date and text data types using ADO method, it gives an error message that reads wrong search type. When I used same search string in DAO, it gives perfect result. How can I use date type combined with tex data type in ADO? Is there any change in search format in ADO than DAO?

Regards,

RADM

 

[RoyVidar]

Depends on which method of searching you use. If you use the .Find method of the ADO object, it's only good for single column search. If you need to search more than one column, take a look at the .Filter property.

Roy-Vidar

 

[PHV]

And I presume it's better to use single quotes for SQL literal constants.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RADM]

Hi,

Yes Roy, I got perfect answer when I used Filter property. But while using Find, it gives error messages. But while working with more number of records, will it be slow with .Filter property?

Regards,

RADM

 

[RoyVidar]

On the contrary. Since .Filter doesn't requery per each "Find", it should be faster.

Roy-Vidar