Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bug in VFP9 with NODATA in remote views ?
Message
From
09/05/2006 17:02:52
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MySQL
Miscellaneous
Thread ID:
01120484
Message ID:
01120543
Views:
23
>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.

The key word here is "seemingly". There must be a column where the size differs, depending on whether you have data or not. Then change your view definition so that it can't return varying length (cast it as proper fixed-length type).

This happens even with local views, when VFP determines the column sizes from the first record.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform