Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update conflict in cursor 'MyView'
Message
From
09/05/2006 11:36:53
 
 
To
09/05/2006 09:16:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Novell 4.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01120165
Message ID:
01120397
Views:
44
Now I figured that the Tableupdate is not successful, but it returns .T. nevertheless:
lcFieldState1 = GETFLDSTATE(-1,"MyView") && returns 111211
llSuccess = TABLEUPDATE(.F.,.T.,"MyView",laError) && returns .T.
lcFieldState2 = GETFLDSTATE(-1,"MyView") && returns 111211
*
IF NOT llSuccess
	*-- llSuccess = .T. so this does not fire.
	=AERROR(laError)
	=MESSAGEBOX(laError[2])
ENDIF
*
=REQUERY("MyView") && Error: Update conflict in cursor 'MyView'
This turns out to be a very difficult thing to solve.

>The tableupdate is successful, I checked the return value. There must be another reason for the error.
>
>>Check Re: Refreshing the data Message #1119917
>>
>>>
>>>I am using a view, buffering 3, and I have the following code:
>>>
=TABLEUPDATE(.F.,.T.,"MyView")
>>>=REQUERY("MyView")
>>>If the result of the requery would be an empty view, which may happen, I receive at line 2 the following error message:
>>>
Update conflict in cursor 'MyView'
>>>The help suggests to use TABLEUPDATE(), this is why I put in the first line, but it does not change the behavior.
>>>
>>>What could be the problem?
Christian Isberner
Software Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform