>I'm using a local view with Buffer mode override = 5 (Table buffering). After some insertions, some validations involving seeks and some Set Order's, I issue TableUpdate(1) which returns .T.
>
>However the function GetFldState(-1) returns a string of 3's (33333333) and the next time I try to insert a new record I receive the error: 'Table is in use by another user'.
>
>Any hints are greatly appreciated
>
>Oscar
Oscar,
First your tableUpdate is assuming that the correct work area is selected. It is advisable to use all the arguments for TableUpdate and TableRevert to prevent bugs of something changing a work area on you.
TableUpdate(1,.F.,"MyCursor")
Second your getfldstate is telling you that you are on a new blank record in the cursor. I believe you want to Requery("MyCursor") for teh local view to clear it of the curretn status and update it from the original tables.