Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableUpdate
Message
 
To
26/07/1999 20:32:34
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00246393
Message ID:
00246410
Views:
16
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform