Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Opening table via VPN
Message
De
08/11/2011 13:07:39
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Opening table via VPN
Versions des environnements
Visual FoxPro:
VFP 6 SP5
Divers
Thread ID:
01528403
Message ID:
01528403
Vues:
81
Can I open (and update) table on another location without opening their database? For example
FirstPath = "C:\Program"
SecondPath = "Z:\Sample"
I want to update table (which is sane structure) on secod location with data on a first location via VPN connection.
Openning table on a second location takes some time and I want to shrink that time for openning.
Table is with about 1000 records. I can use it as a local table.
Database name is a same on both location. How can I close second database after transaction below?
SET DEFA TO C:\PROGRAM
SELE 0
USE SecondPath + "SampleTable" ALIAS SecondTable

SELE 0
USE SampleTable
SET RELATION TO Id INTO SecondTable

SCAN
   REPLACE SampleTable.FieldValue WITH SecondTable.FieldValue
ENDSCAN

SET RELATION OFF INTO SecondTable
Thanks in advance.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform