Search for record in TSQLQuery
lazarus / 16-Databases

----------------------------------------------------------------------
thaimann · 2005-05-15 05:02

Can some one at least tell me what the method is to search for a
record in a  TSQLQuery?

----------------------------------------------------------------------
matthijs · 2005-05-17 06:39

As the LookUp and Locate methods are not yet implemented you have two
methods:
1. Use another TSQLQuery in which you have a SQL-statement with a
"WHERE"-clause.
2. Open your query sorted on the field(s) you want to search on and
step trough the records till you have found the record you are looking
for.