Hello,

I somehow got used to it, but it is nevertheless annoying: When doing a COUNT(*) in MySQL, mySQL creates a BigInt data type of the result. In the VFP view, the result is a character value. In order to do further calculations I have always to keep that in mind.

Unless somebody has a trick to get the result as a numeric type in MySQL?

I am using ODBC driver 5, same was with version 3.