| Subject | Re: [IBO] Searching by range |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-08-17T00:27:29Z |
At 09:44 AM 16/08/2005 +0000, you wrote:
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
literals.
Helen
><Using D5/FB/IBO 4.5b>Your approach is appropriate. Set up the query without the search string
>
>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?
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
literals.
Helen