Recent

Author Topic: Search for record in TSQLQuery  (Read 4802 times)

thaimann

  • Jr. Member
  • **
  • Posts: 84
Search for record in TSQLQuery
« on: May 15, 2005, 07:02:42 am »
Can some one at least tell me what the method is to search for a record in a  TSQLQuery?

matthijs

  • Hero Member
  • *****
  • Posts: 537
Search for record in TSQLQuery
« Reply #1 on: May 17, 2005, 08:39:07 am »
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.
What's in a sig? Would my posting look less if it didnot have a sig? (Free after William S.) :)

:( Why cannot I upload my own Avatar? :(

 

TinyPortal © 2005-2018