Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The difference between USE ... in 0 and USE ... AGAIN in 0
Message
From
01/04/2001 22:33:24
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
The difference between USE ... in 0 and USE ... AGAIN in 0
Miscellaneous
Thread ID:
00490801
Message ID:
00490801
Views:
51
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
Next
Reply
Map
View

Click here to load this message in the networking platform