Bonnie,
This looks VERY much like the elusive problem described by MSKB #
293638 and presently reported as "fixed" by VFP8. I should add that it has been reported here as occurring outside of TRANSACTIONS too.
My view is that VFP8 does NOT "fix" it, but rather "traps" it to assist in preventing loss of data.
If you have a reasonably reproducible situation then you might hold the key for a genuine FIX and I'd bet that addressing a thread to MS support folks who hang out here, like Jim Saunders, would be greatly appreciated.
At the very least, if you would post as many particulars as possible here it would help some.
good luck with the problem.
>I have a form that occasionally looses appended records (after the tableupdate). This is a multi-user app. The table is in 'table buffering mode' and I've created a big error log that seems to show events running like this:
>
>1. Record is appended; record # is -1
>2. Record is saved successfully to the util_rev table with:
> TABLEUPDATE(1,.F.,'util_rev')
> The above command return .T.
> record # is 60467
>3. This happens 4 or 5 times (4/5 records added successfully with RECNO() being increased to 60472)
>4. Go to EOF
>5. The last record is 60467!!! what happened to the other new records?
>6. Record is appended; record # is -1
>7. Record is saved successfully to the util_rev table with:
> TABLEUPDATE(1,.F.,'util_rev')
> The above command returns .T.
> record # is 60467 AGAIN!!!
>
>Any ideas??
>
>thanks
>
>bonnie