Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update conflict in cursor 'MyView'
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Novell 4.x
Database:
Visual FoxPro
Divers
Thread ID:
01120165
Message ID:
01120397
Vues:
40
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform