search value in table

johnkuiper · Post by **johnkuiper** » Mon 07 Jan 2008 10:19

As far as I know, searching a particulair value in a table you have to do serveral things like using MyQuery, put an SQL with a parameter in it, set the value of the parameter, open MyQuery, check the recordcount and close MyQuery.
Is there a simple way to accomplish this procedure

Antaeus · Post by **Antaeus** » Tue 08 Jan 2008 09:48

There is no simpler way to do this. The only hint I have is to use the SELECT COUNT(*) FROM table WHERE ... command instead requesting all records and checking record count with DataSet.RecordCount.