Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
File Locking
Message
 
À
10/12/1999 09:09:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00301584
Message ID:
00301648
Vues:
19
>Hi Chris.
>
>Are you trying to use APPEND FROM to append data from the network tables? Hmmm...OK, two things. Is SET EXCLUSIVE OFF? It should be. Second, if you have no way of knowing if the network tables are in use by another process, the safest way to do your append may be to open the network table for shared access, copy it to a cursor, and APPEND FROM the cursor. As in:
>
>USE networktable IN 0 SHARED
>SELECT * FROM networktable INTO CURSOR foo
>USE IN networktable
>SELECT localtable
>APPEND FROM foo

Heya Gonz,

The above probably won't work. APPEND FROM requires a file not an alias name. Further, if a filtered representation of the table is created (which it probably will be), there won't be a file other than the original, so the original problem may remain. So...
USE networktable IN 0 SHARED
SELECT * FROM networktable INTO CURSOR foo NOFILTER
lcfile = DBF('foo')
USE IN networktable
SELECT localtable
APPEND FROM (lcfile)
George

Ubi caritas et amor, deus ibi est
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform