Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is the best method ?
Message
From
09/12/2013 15:49:55
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01588801
Message ID:
01589614
Views:
45
>This has to do with the current session on the current station only. Right?
>Or do I have to also be concerned about other sessions on other stations? (meaning whether they have unsaved changes?),

Current session on the current station only.

>
>Cyrus
>
>>>Using VFP8 in Multi-User environment submitting changes via Transaction.
>>>What is the best way to deal with:
>>>
>>>"Cursor cannot be modified because it contains unsaved changes" (error 2072).
>>>
>>>Error 2072 is not listed in VFP Help files. Can somebody explain exactly what is really happening?.
>>>I know if there are unsaved changes in memory, I can submit them to disk using TABLEUPDATE() - or discard them using TABLEREVERT()
>>>
>>>What I am not sure exactly is the mechanics of how the table gets into this state?
>>>
>>>Thanks
>>
>>Somewhere code made a change to the cursor. It may be intended or accidental. Since the change was not handled with a tableupdate, you get this error. Where that change happened is what you need to find. Clearing the change with either tableupdate or tablerevert at the point of the error message is the wrong thing to do. That's dealing with a symptom, not the cause.
Previous
Reply
Map
View

Click here to load this message in the networking platform