Hi Naomi.

Just comong back to this now.
Still dont know how to get the count in Sql and test it.
x=Convert.ToInt32(Convert.ToDouble(rdrCount["CALLS"].ToString().Trim()))

If I use the above, and zero records are 'calculated', a single record with a Blank in CALLS field is returned
If say 20 records are returned, 20 (an INT) is returned in CALLS

Is there a way to test the Type of CALLS in c#

----- Pseudo Code ----------

If TYpe(Calls) is Blank and Calls = Spaces
Then assume no records returned
Else
x=Convert.ToInt32(Convert.ToDouble(rdrCount["CALLS"].ToString().Trim()))
Endif


Regards,
Gerard




>>Ni Naomi.
>>I'm running VFP8
>>I wonder why this woudl have changed from 8 to 9
>>regards,
>>Gerard
>>
>>
>It was changed in VFP9 to be more ANSI-SQL standard. It sure caused some maintenance and hard to find bugs, although the behavior is documented and also was discussed here in the forum.