Page 1 of 1

search value in table

Posted: Mon 07 Jan 2008 10:19
by johnkuiper
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 :?:

Posted: Tue 08 Jan 2008 09:48
by Antaeus
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.