Hi Ricardo,

The error indicates that the server produces results with different schema for "USE RoomType" and for "USE RoomType NODATA". It is easy to check, compare the schema for cursors created by VFP. To avoid this error, try to adjust the query to return result with the same schema regardless whether NODATA is used.

Thanks,
Aleksey.


>I have read this article about fixed problem in VFP9.
>
>http://support.microsoft.com/kb/894011/EN-US/
>
>But the error stay there.
>I have a remote view in a DBC VFP with mySQL5
>

>SELECT Roomtype.descrip, Roomtype.rooms, Roomtype.features,;
>  Roomtype.pic_path, Roomtype.pic360_path, Roomtype.roomtypeid,;
>  Roomtype.roomTypeCode;
> FROM ;
>     roomtype Roomtype;
> WHERE  Roomtype.roomtypeid BETWEEN ?nRT_ID1 AND ?nRT_ID2
>

>
>The next example gives an error "View definition has been changed (Error 1494)"
>

>nRT_ID1 = 0
>nRT_ID2 = 999
>USE RoomType NODATA
>REQUERY()
>

>
>but, if use the same example without "NODATA" parameter, works fine.
>
>Any idea ?
>Thanks.