Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Searching with 2 different data types in ADO

Status
Not open for further replies.

RADM

Programmer
Dec 27, 2003
36
IT
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
 
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
 
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
 
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
 
On the contrary. Since .Filter doesn't requery per each "Find", it should be faster.

Roy-Vidar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top