Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field States Changing
Message
From
16/11/2004 15:15:54
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Field States Changing
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00961892
Message ID:
00961892
Views:
35
In opne of our Mere Mortals based applications, we have an old “ghost user” issue, where we get multi-user conflict errors, even though the system is single user. One cause is as follows:

Copying Records

TableUpdate thinks a change occurred in the base table that now conflicts with the current view/cursor, although, manually, could not find any differences. TableUpdate then triggers an "another user has made changes" error. Later found when copying a record for the problem tables above:
• Data from source record SCATTERed
• Record appended
• GetFldState() initially shows appropriate values for the new record
(3s and/or 4s - appended record)
• Data SCATTERed into the new record.
• Later call to business object’s Refresh method sets GetFldState
values back to 1's and 2's (record not changed or record edited).
• Attempted TableUpdate generates the error.
I'm guessing this causes TableUpdate to think the base table changed, as it now thinks the copied record was simply an edit of an existing record instead of an addition, but the view's new copied record does not exist in the base table. It thinks another user changed the base table.

Other table maintenance routines do not do this, hence they work. The custom record copying code seems to be the same.

Are there any internal FoxPro situations that would change the field state like that?

Thanks
GOOOOOOOO BUCS !!!!!!!!!
Reply
Map
View

Click here to load this message in the networking platform