Subject | Re: [IBO] search on several criteria at the same time |
---|---|
Author | Jason Wharton |
Post date | 2003-10-22T16:38:32Z |
With IncSearching I think you should limit it to one column.
Using something like search edits could help.
Either that or the Locate() method can be setup to operate on multiple
columns.
You might try it and see if it will help.
Jason Wharton
Using something like search edits could help.
Either that or the Locate() method can be setup to operate on multiple
columns.
You might try it and see if it will help.
Jason Wharton
----- Original Message -----
From: "Gediminas" <gugini@...>
To: <ibobjects@yahoogroups.com>
Sent: Sunday, October 19, 2003 2:28 PM
Subject: [IBO] search on several criteria at the same time
> trying to implement searching on several criteria at the same by using
such
> code:
>
> select "Name" , "Surname" , "City"
> from Table
> where "Name" starting with :Name and "Surname" starting with :Surname and
> "City" starting with :City;
>
> problem is, that such parametrized search is very slow - every time when a
> key is pressed (in paramedit) - query is send to DB to retrieve dataset.
is
> it possible such searching implement on buffered dataset? don't image, how
> would it be possible to use IncSearch in such case - is it possible such
> searching with IncSearch at all?
>
>
>
> --/ Gediminas /--
> The Truth Is Out There