Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't open file exclusively
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
00999492
Message ID:
01000114
Vues:
18
I typed the wrong table name by mistake in my previous reply...
If the database is open and set as the current database, you should
not have to use the syntax to refer the database when opening the table.

What is the value of dbc() right before you run the code? I was curious to see if you might get an unexpected result at the client site if you run the following code, that is all...
try
   *-- instead of this code:
    * select 0
    * use crossref!sc_parts
   
   *-- this instead
   *-- make sure your database is open and set at the client site as well...
   wait window dbc()
   wait window used('sc_parts')
   use sc_parts in 0
   
catch to ErrObj
   MsgText = "Error " + transform(ErrObj.ErrorNo) + ":  " +;
             ErrObj.Message +;
             gcCRLF + gcCRLF +;
             iif(ErrObj.ErrorNo = 1705,;
             "The SC_PARTS table could not be opened exclusively." +;
             gcCRLF + "Close all other forms and try again.", "")
   messagebox(MsgText, 64, "Import List Prices")
   OkToContinue = .f.
endtry
if not OkToContinue
   return
endif
>Stacy-
>The thread you referenced came down to a difference between the meta data on the development machine vs. the production machine. That shouldn't be the case here, since one of the things I did was send a new copy of the meta data and then have him run the update routine, which syncs the existing tables to the new structures, if any changes were made. So we should be in sync, however I'd better confirm that this all happened correctly.
>
>The code you suggested will be redundant - the DBC is already open and already set as the current DBC. I will confirm that one more time, though.
>
>Thanks for the continued efforts!
>
>>*-- did you happen to move your dbc in your developer env at some time?
>>*-- try this...
>>
>>
>>try
>>   open database crossref
>>   set database to crossref
>>   use crossref in 0
>>catch to ErrObj
>>   MsgText = "Error " + transform(ErrObj.ErrorNo) + ":  " +;
>>             ErrObj.Message +;
>>             gcCRLF + gcCRLF +;
>>             iif(ErrObj.ErrorNo = 1705,;
>>             "The SC_PARTS table could not be opened exclusively." +;
>>             gcCRLF + "Close all other forms and try again.", "")
>>   messagebox(MsgText, 64, "Import List Prices")
>>   OkToContinue = .f.
>>endtry
>>if not OkToContinue
>>   return
>>endif
>>
>>
>>
>>
>>*-- also, try looking at thread #866546 as it may be relevant here?
Thanks,

Stacy



Black Mountain Software, Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform