Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
The difference between USE ... in 0 and USE ... AGAIN in 0
Message
De
01/04/2001 22:33:24
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
The difference between USE ... in 0 and USE ... AGAIN in 0
Divers
Thread ID:
00490801
Message ID:
00490801
Vues:
52
Hi all,

I encountered strange situation on updating, actually transaction.
I opened same parameterised,updatable,local view in 'USE ...again in 0'
2 times with diffrent alias and do some jobs to reflect data changes as follows.

lcAlias=SYS(2015)
lcFile="lv_someview"

FOR n=1 to 2
IF n=1
vcParms=parmsA && paremeters
ELS
vcParms=parmsB
ENDIF

USE (lcFile) again in 0 alias(lcAlias) && view open..
select (lcAlias)
=CURSORETPROP("buffering",5)

SCAN
* data handlings
....
....
ENDSCAN

ENDFOR

And then on issuing =tableupdate(), RLOCK() returns .f. and failed to update
on edited records.But newly added records in both views, there was no problem.
After replacing 'USE ...in 0' vc 'USE ...agin in 0', there is no problems rega-
rdless of edited or newly added record.
Anyhow the problem was solved, but someone enlighten me what is the difference.

Thank you.
H.K.Lee
MCP
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform