Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
File Locking
Message
De
10/12/1999 10:20:17
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
10/12/1999 10:17:37
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00301584
Message ID:
00301693
Vues:
21
>>>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)
>
>
Hi George,
>AFAIK also "Append from foo" works.
>Cetin


Forget it :) It was another select that's working.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform