>>Capture the ODBC log for this code:
>>
>>nRT_ID1 = 0
>>nRT_ID2 = 999
>>USE RoomType
>>
>>USE RoomType NODATA
>>REQUERY()
>>
>>and post it.
>
>Fabio, please check this link (mySQL.LOG 110KB)
>
>
http://c-dev.net/Test/mySQL.LOGthe exact VFP code is it ?