Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Odd Database share/exclusive behavior
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00208957
Message ID:
00208994
Vues:
25
Thanks Bruce, was doing some testing earlier and found
out that if I issue a close database first, then I get
the response I was expecting. But you've just explained
why.

Thanks again.

>>Hi All,
>>
>>I'm writing a utility that packs all the tables in a
>>DBC. Part of the code involves checking if I'm able
>>to have 'exclusive' use of the DBC by traping the
>>error code and checking for error #1705 - File access
>>denied.
>>
>>The problem is that when I was testing it using two
>>PCs on a network, it worked fine. But when I tested
>>it from the application (.exe) it was not even getting
>>the error I was expecting.
>>
>>Part of the code I'm using is:
>>
>>on error aerror(laError)
>>
>>open database TESTDATA.DBC exclusive
>>if laError[1] = 1705
>> wait window "Exclusive use of Database is required!"
>> return
>>endof
>
>You have to make sure the dbc is closed first. If you issue
>
>open database TESTDATA.DBC exclusive
>
>on an already open SHARED dbc, the command is simply ignored.
Speak using soft and sweet words in case you have to eat them later.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform