Forum > Databases

Search for record in TSQLQuery

(1/1)

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.

Navigation

[0] Message Index