Subject | search on several criteria at the same time |
---|---|
Author | Gediminas |
Post date | 2003-10-19T21:28:10Z |
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
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