Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update conflict in cursor 'MyView'
Message
From
10/05/2006 02:16:47
 
 
To
09/05/2006 11:36:53
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:
01120609
Views:
31
>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?
lcFieldState1 = GETFLDSTATE(-1,"MyView") && returns 111211
? "Check ",CURSORGETPROP("BatchUpdateCount","MyView")=1
llSuccess = TABLEUPDATE(2,.T.,"MyView","laError") && returns .T.
lcFieldState2 = GETFLDSTATE(-1,"MyView") && returns 111211
Previous
Reply
Map
View

Click here to load this message in the networking platform