Aleksey, Thanks you for your quick answer.

Anyway I must work with mySQL and this data scheme, I'm changing this tier as fast as possible from R.V. to CursorAdapter class.
I did some tests extending CursorAdapter class and this working very well (with ODBC) and NoData property.

Regards.




>>http://c-dev.net/Test/mySQL.LOG
>
>Hi Ricardo,
>
>Based on this log, the [roomTypeID] column is definitely the root of the problem. When column information is retrieved after SQLPrepare, the DisplaySize = 0 and Precision = 0. However, after the same query is executed, the DisplaySize = 1 and Precision = 1. SQLPrepare is often used to get schema information, therefore schema of the result returned after SQLExecDirect is expected to be the same. Even though DisplaySize and Precision returned by an ODBC driver do not explicitly affect cursor's schema with regard to an Integer column, VFP pays attention to these values when it checks whether result's schema has been changed.
>
>Thanks,
>Aleksey.