Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Should I allow time for USEing a table?
Message
 
 
À
17/04/2008 19:14:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01311596
Message ID:
01311627
Vues:
18
Thank you, Tracy. I already checked one of the messages you references and it could lead to a solution. My code is very simple (and it works in most other customer settings). It is USE (table) SHARED, that's all. And in some cases, particularly this customer, it fails with the error 108. I will further read on the references you quoted here.

>There could be many things happening. Is the header being locked? Or the database? Do you use transactions? Are you using buffering? Is exclusive off? Are these free tables? You can try something like in the message below and see if it makes a difference and then, if not, proceed from there:
>
>Re: Attempting to lock Thread #1282563 Message #1282736
>
>Also check this:
>
>Re: Error 108: What gives? Thread #1175426 Message #1175580
>
>It would be better if you could post more information on the method you currently use for opening and editing a record in a table.
>
>
>>Hi,
>>
>>A customer says that every so often they get an error message 108 File is in use by another user. I suspect that the server where data reside could be causing the problem. Maybe, another user on another application is attempting to read or write. I don't know. But I was thinking to set a timing loop when USEing (opening) a table to allow for, say, 5 or 10 seconds. Currently, my code simply attempts to open a table once and if it fails, reports a problem.
>>
>>Is it a good design practice to allow some time for a table to be opened?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform