>Dragan, Aleksey:
>Thanks for your help.
>
>I compared both schemas and they are identical.
>One of the columns is INTEGER datatype and also is autoincrement (remember i'm working against mySQL 5).
>VFP takes this column like "I", to avoid varying length, I changed SQL source code for:
>

>DBSetProp(ThisView+".roomtypeid","Field","DataType","N(10)")
>

>But the error message continue.
>
>Is possible that the error be produced when working with mySQL integer column autoincrement ?
>If I remove this column from the mySQL table, all works ok.
>
>Unfortunately I can't change the DB engine, let alone doing permanent changes in the structure.

Capture the ODBC log for this code:

nRT_ID1 = 0
nRT_ID2 = 999
USE RoomType

USE RoomType NODATA
REQUERY()

and post it.