>>Yes I believe you can use 'replace' along with seeks
>>
>>=seek(something,'thetable','theindex')
>>replace something with somethingelse
>>
>>I believe will avoid the locks issue - if thats what you have!
>>
>>John
>
>Basic structure is (obviously not the exact or the entire code)
>
>SELECT x
>BEGIN TRANSACTION
>SCAN
> REPLACE a WITH b
> FOR m.i = 1 to 2
> calculate memory variables
> GOTO BOTTOM IN y
> INSERT INTO y FROM MEMVARS
> GOTO BOTTOM IN z
> INSERT INTO z FROM MEMVARS
> ENDFOR
>ENDSCAN
>
>=TABLEUPDATE(.T.,.F.,x)
>=TABLEUPDATE(.T.,.F.,y)
>=TABLEUPDATE(.T.,.F.,z)
>END TRANSACTION
>
>
>not clear where and what =seek(...) I would use here. Do I figure out what the key field is and re-seek it?
Hi Claude,
This probably doesn't relate to your TABLEUPDATE problem, but your GOTO BOTTOM statements aren't needed because INSERT INTO will automatically insert at the end of file. Oh, and I assume your aliases in your TABLEUPDATE are enclosed in quotes?
Regards,
Jim