Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bug in VFP9 with NODATA in remote views ?
Message
De
09/05/2006 17:01:02
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MySQL
Divers
Thread ID:
01120484
Message ID:
01120542
Vues:
24
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform