Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating offline views
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Updating offline views
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01015187
Message ID:
01015187
Views:
60
Does anyone have any experience using offline views in VFP where the modified data is subsequently send up to the online table?

I start with a local view and then use the createoffline() function to take it offline. When ready to update, I am using USE viewname ONLINE EXCLUSIVE. TABLEUPDATE should then work to send changes to the orginal online table. Tableupdate fails with no error other than the record number of the changed record. It is not a conflict problem as there are no other users at the time.

The source table is located on the server in DBC1. The local view is on the client machine in DBC2. When the offline view is created, the DBC2 is set. I am not sure what special requirements need to be set for db properties or indexes. Should the offline view become part of the local view database? Should its name be different from the local view? (Now I am grasping at straws.)

Any suggestions from someone experienced with this would be appreciated.
Thanks much,
Nancy
Reply
Map
View

Click here to load this message in the networking platform