Hi:

Using VFP 8.0 to query MySQL through ODBC with myodbc verion 2.50 works fine
but using version 3.51 returns currency fields instead of numeric/decimal
fields

I know you need to set the version to SQL_OV_ODBC2 using SqlSetEnv
But I haven't a clue on how to do it or when to do it - before
making,during,or after making connection

Can something be put in options of ODBC or SQL command on Connect

Visual Foxpro does not have a command called SQLSetEnvAttr

Only command I know to send query to server is Sqlexec()

My connection setting are
ODBCString=DRIVER={MySQL ODBC 3.51
Driver};SERVER=Localhost;UID=?;PWD=?;DATABASE=maps;option=3

Any help would be appricated,

Alberto