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