Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to set a file as Exclusive
Message
 
À
30/05/2003 06:49:44
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00794408
Message ID:
00794466
Vues:
13
Hi Cetin.
Yes. this is the reason why it should be exclusive.
So what I want to do is:


Sele MyFile
If nobody else has the file open
Open it exclusive
Zap it
Endif
Open it shared again

This has come about because of the following:

A file that a match was being done on has say 700,000 records
If a particular condition arises, a complete rematch needs to be done.
Up to now , I used a delete all, and re-did the match... it was going to take 2 weeks (yes 14 days we reckoned) non stop processing.

I zapped the file and it took 20 mins !!!


regards,

Gerard




>>Hi.
>>I have all my Tables set up in DE, and Set Exclu is off.
>>However, there is one case where I need to be able to temporarily open the table exclusively, because I want to Zap the file.
>>
>>If I set exclu on, it does not work for tables already opened.
>>How do I do this for a table that is already opened, Zap the file, and then go back to using it non exclusively.
>>
>>regards,
>>
>>Gerard
>
>Gerard,
>Impossible. Assuming it was possible for a moment why would you ever want to do that. Think I'm user xx on station yy and have that table open, you zap and suddenly out of the blue the table I'm working on has no records !
>Cetin
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform