Re: How to use LIKE operator with Filter prop of recordset for num fie
- From: "Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom>
- Date: Thu, 9 Mar 2006 16:29:15 -0000
Is it possible to organize a 'quick search functionality' in the table byfaster.
meanse of the Filter prop. I wouldn't like to requery. Filter works
Can someone give me examples for numeric and date fields?
Have a look here
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprofilter.asp
which gives some details on LIKE and its limitations. It is not as flexible
as SQL's LIKE operator.
Also see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprooptimizepropertyrds.asp
which can improve performance.
Stephen Howe
.
- Prev by Date: Re: Recordset & Sort
- Next by Date: How select from 2 ADO.NET DataTables?
- Previous by thread: Re: How to use LIKE operator with Filter prop of recordset for num fie
- Next by thread: Re: i need some guidance
- Index(es):
