Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating offline views
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Updating offline views
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01015187
Message ID:
01015187
Vues:
61
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
Répondre
Fil
Voir

Click here to load this message in the networking platform