Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange Status - Locks = 6161
Message
De
08/12/2004 13:45:26
 
 
À
08/12/2004 06:57:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 7 SP1
Divers
Thread ID:
00967697
Message ID:
00967829
Vues:
12
I would do the basic troubleshooting:

1. There is no if found() .or. !eof() etc after the seek to verify you are not at the end of file.
2. Set step on after the seek and what are the values and TYPE of:

thisnewid
thisform.txtnewId.value
idnumber
thisnewid
entry
oParam.thisinits

Verify whethe each value is character as well as the field type, etc.


>Dear Foxperts
>
>A colleague has asked me to look into this problem. please observe the code below:
>
>sele m_cust
>set order to idkey
>thiskey=oChist.idkey
>seek thiskey
>thisrec=recno()
>thisnewid=thisform.txtnewId.value
>repla idnumber with thisnewid,;
>	entry  With oParam.thisinits+':'+Dtoc(today)
>
>
>An error occurs at the last line: to wit:
>
>
File is in use by another
>
>Now there are no other users on. This code is used for several sets of data (each customer has his own set) and only occurs with the data for a particular customer. It is a private dataset and the tables are opened shared.
>
>This occurs on one form with 31 tables opened in the data environment. This form also calls another which
>has a private data session - which also uses M_CUST.
>
>He looked at the status of his VFP environment (DISP STAT) and discovered, at the "Lock(s)" header for the table, M_CUST, instead of "none" or "Exclusive use", a value of "6161"
>
>There is no guide for parts of the disp stat output in Help and I'm stumped too.
>
>Any ideas?
>
>Thanks
>
>Terry
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform