Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Force a table close
Message
De
23/02/2007 18:48:29
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01198482
Message ID:
01198490
Vues:
13
The dialog is labeled Program Error
The message says:

Database
\\tpdfiles\data\dfreeman\trp\data\surveys\newsurveys.dbc
File access denied.

It seems to be a problem that the database is not closed even though the command
close databases all
is executed.

>What's exact error message/error code?
>
>>Oops! I should have said "If I exit and then restart VFP. . . " Its a prg that I run from the run button in proj manager.
>>
>>>Where do you run code after exiting VFP? Separate application?
>>>
>>>>After running some other code which uses these tables, the following code produces an error on the first use stating the file is not available. If I exit VFP and then run the code it works OK. How can I force a close to make sure the tables are available?
>>>>
>>>>
>>>>close tables all
>>>>close databases all
>>>>set exclusive on
>>>>
>>>>use \\tpdfiles\data\dfreeman\trp\data\surveys\rawdata2005 in 0 alias rawdata2005
>>>>use \\tpdfiles\data\dfreeman\trp\data\surveys\history in 0 alias history
>>>>use \\tpdfiles\data\dfreeman\trp\data\surveys\companyinfo in 0 alias companyinfo
>>>>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform