Hello Wilfried,
your query will have as many result - Rows as meet your where-clause.
A Better way will be
select count(*) from tx where VehicleID = ' + QuotedStr(VehicleID)
This will have one result row with the number of records in the first
(and only) column.
Martin
Wilfried Mestdagh schrieb:
Hello,
I want to have only the count of records for a particular 'where
clause', need no fields. It works using null as argument:
'select null from tx where VehicleID = ' + QuotedStr(VehicleID)
Is this the right way to do or is there a better way ?
---
Mvg, Wilfried
http://www.mestdagh.biz
