What buffering mode are you using with cursorsetprop? Is it 4 or 5? Look at Buffering Data under help and it explains table buffering with tableupdate()
>Hi everybody,
>
>I'd like to understand if the behavior we're getting with transactions is what we should expect or there is some anomality here.
>
>Here is the scenario:
>
>When doing imports we put table buffering on bunch of our tables: Trans, Patients, Names, Address, Phones, etc. We then do various processes with the tables (inserting data or modifying data). Finally when it's time to commit the changes we do
>
>begin transaction
> llUpdate = tableupdate(.t.,.t.,"First Table")
> if not llUpdate
> rollback
> tablerevert all the changes done previously
> close the process
> endif
> ...
>end transaction
>
>Now in the separate VFP session we try to open tables used in the process. Prior to executing tableupdate we can open and close the table. But once the tableupdate is issued, we're getting "File is in use" error.
>
>So, is it the right behavior? The changes for that table are already happened through tableupdate, though the transaction is not yet closed.
>
>Thanks a lot in advance and suggestions.
.·*´¨)
.·`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"