table buffering

[DannC]

Hi friends,

i begun to use table buffering for a short time and i've run into some problems, hopefuly Tek-Tips can help us:

1. when I issue cursorsetprop("Buffering",2,alias()) on a table is supposed to be a pessimistic table buffering, but if a append blank command is issued and after that a tablerevert(.t.) the empty row isn't "dissapearing".

2. cursorsetprop("Buffering",2,alias()) case : if i have a table from a database opende by two users and if one of them has tablerevert(.t.) that means that all records from the table are reverted or only from the user's station.

3. is there any function or method to see is the buffer is commited ?

Thanks

 

[ramani]

Hi...
The tablerevert() removes the appended blank record under the buffering you said above. However remembr that if the record pointer is moved, a commit is taking place and so the table revert doesnt work. To test this... from the command window..crate a table test with fields fld, fld2..
Append a couple of records... set multilocks on...
Issue the command...
cursorsetprop("Buffering",2,alias())
and now the test arena is ready
Now issue append blank
brow
press escape
tablerevert()

brow... the appended record will not be there
No repeat but while brow after append .. move the up arrow key... press esc.. and then do tablerevert() and brow... the apended record will be present.

Only the users records will be reverted()

So your issue will get explained with thes tests, I hope...
ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com

 

[fluteplr]

2 is not pessimistic table buffering it is pessimistic ROW buffering. As soon as you move the record pointer off the row, which is really easy to do accidentially, the record is committed.

4 is pessimistic table buffering

 

[DannC]

thank U all. i'd figure it out ... for the moment