Why don't MySQL math expresions work with the Database toolkit?

[Thomas_robertson]

If you use the database toolkit to execute:
Select 1+1;

on a MySQL database (conecting through MyODBC), the recordset returned has no data and geting it's column properties cause a Warning (Type not supported) to be thrown by the Database Conectivity Toolkit.

[Jeremy Braden]

Each database has some special commands that it uses. I suspect select is not a standard odbc command and won't work with the database connectivity toolkit.

Jeremy

[Thomas_robertson]

I figured it out.

Select Round(1+1);

this will force MySQL to convert the 'expresion' data type (or whatever it was trying to return) to an integer which the Database toolkit understands.