Search for record in TSQLQuery

[thaimann]

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

[matthijs]

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.