Hi Ricardo,

What does "seemingly the same" mean? Is it exactly the same or not?
Don't immulate NODATA with special parameter's value. If I understood you correctly, you are saying that the following code works:

nRT_ID1 = 0
nRT_ID2 = 999
USE RoomType
REQUERY()

But this code doesn't work and reports the "View definition has been changed" error :

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

If this is the case, you should compare cursor's schema after USE command for both scenarios. If schema is not the same, that is the problem.

Thanks,
Aleksey.

>Sorry Aleksey, how can I compare the schema ? with DISPLAY STRUCTURE after the USE command ?
>Both TMP cursors have (seemingly) the same structure.
>I can emulate NODATA behavior, with negative values in WHERE variables of remote view.
>
>T.I.A.
>
>>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.