Subject Re: [IBO] Searching by range
Author Helen Borrie
At 09:44 AM 16/08/2005 +0000, you wrote:
><Using D5/FB/IBO 4.5b>
>What IBO components are best for searching by range?
>For example I want to search for invoices with numbers
>1001 to 1020? Or invoices entered between 8/01/2005 to 8/15/2005?
>I'm contemplating on using ordinary TEdits with IBQuery.onprepareAQL.
>Perhaps there are components specially made for this purpose,
>or did I just miss this in a docu somewhere?

Your approach is appropriate. Set up the query without the search string
and use the OnPrepareSQL event to set the search criteria via
SQLWhereItems. Tip: for date searches, be sure to use date/time variables
and TMaskEdits, to avoid getting caught up in problems with valid date/time