Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Chr(0) damage
Message
From
04/07/2001 12:06:44
Larry Long
ProgRes (Programming Resources)
Georgia, United States
 
 
To
04/07/2001 10:49:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00526682
Message ID:
00526708
Views:
15
This message has been marked as a message which has helped to the initial question of the thread.
Try using ODBC to access the data using remote views. I may not have all the correct steps, but it would be something like this...
1) Go to the ODBC setup from START-SETTINGS-CONTROL PANEL
2) Create a System DSN using the MS VFP Driver and designate the free table as your source.
3) Add a connection to your app's DBC to target the new ODBC data source.
4) Create the remote view.

HTH
Larry

>The operation of our main app involves the distribution of free FoxPro tables across our WAN. For reasons yet unknown, the data sometimes suffers corruption. Randomly, character field data will be replaced by chr(0).
>
>Q1: Does anyone have experience with this problem?
>
>We have recently encountered a corrupted table which FoxPro would happily open but unfortunately would not handle properly. It appears that we can't reliably detect this problem using FoxPro code.
>
>Q2: What would be the best means of handling this kind of damage?
>
>Thanks
L.A.Long
ProgRes
lalong1@charter.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform