>>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.
>
>Can to CAST() result of COUNT() to integer or decimal in the query?
In MySQL Cast can be one of the following types:
Binary
Char
Date
Datetime
Decimal
Signed integer
Time
Unsigned integer
I have tried it before, but if I use signed or unsigned integer, it creates a character result. But now that you mention it I checked and using Decimal does result in a numeric output. I never thought of using Decimal, have to check what they mean with that. Strangely enough, it always displays two decimal points, but for my calculations that will work.
Christian Isberner
Software Consultant