Wilfried Mestdagh a écrit :
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 ?
Hi Wilfried,
a better request would be :
select count(VehicleID) as CountVehicle from tx where VehicleID = ' +
QuotedStr(VehicleID)
then you get the field "CountVehicle" value.
HTH,
--
Guillaume MAISON - [EMAIL PROTECTED]
83, Cours Victor Hugo
47000 AGEN
Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50
e-mail : [EMAIL PROTECTED] - Web : http://nauteus.com