The fastest, easiest way to retrieve your records.
TSearcher is a component which gives its best performances in client/server
applications, where limit the amount of data to that ones which are really necessary is a must. For that reason i've not exploited the dataset filtering instructions, as these instructions, in
particular cases, bring the whole data cursor in your local memory and only here they apply the filter. Viceversa, TSearcher filters the data only at server level. TSearcher builds a SQL statement with
some search criteria that user sets; the used SQL is based on SQL97. Is now programmable with XML scripting language and 100% compatible with TField component.