cursorsetprop buffering lock dbf

[Rottdpogs]

Please advice. Does anyone encounter this before? Im using dbc in a network environment and opening a dbf using cursorsetprop. Problem occur when i use the tableupdate(), it updated the record as can be viewed in a grid. but when i close the dbf and open it again the records i updated are lost, and again typing all the records and update again after i close it loses again when i open. The dbf lock and i use the append without cursorsetprop and delete then it works fine again. Does anyone have a better idea with this. thanks in advance.

 

[gchandrujs]

Be sure using
SET MULTILOCKS ON
for tablebufferings.

As you entering values in the grid using BUFFERING MODE as 5 (table Rowcol Buffereing).

ALSO When updating, use TABLEUPDATE(1). as it updates multiple rows at a time.

gchandrujs

 

[danceman]

Are you using a view, what about the underlying tables that make up the view. All the tables have to be in buerring mode and updated. Attitude is Everything

 

[MCTCO]

sounds like you may be updating the wrong table. try selecting the work area before tableupdate()

cursorsetprop() doesn't open the work area, it just sets table properties.

Select mytablename
Tableupdate()