Forum > Databases

Search for record in TSQLQuery


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

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.


[0] Message Index

Go to full version