Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update conflict
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Miscellaneous
Thread ID:
00143536
Message ID:
00143693
Views:
36
>>1. open form1 (contains view v_mytable)
>>2. form1 calls form2 (contains mytable), private DE
>>3. form2 appends a record into mytable
>>4. form2 closes (modal?) [right, it's modal]
>>5. Form1 does a REQUERY() on v_mytable
>>6. form1 deletes new record in v_mytable
>>7. form1 does a TABLEUPDATE() on v_mytable which results in an update conflict.
>
>You got it! :)
>
>But it you repeat the sequence from 2 through 5 twice, then go on
>6, all is well.
>
>In the original sequence, if I insert
>
>4a. close underlying table
>
>it also works (the requery opens it again).

This is strange. Have you checked if the modal form's datasession is closing cleanly?
What parematers are you giving with the TABLEUPDATE in form1?
Do you get an update conflict when deleting a record besides the newly appended one?
If not, how do you suppose your view can tell the difference between a new and a previously existing record after a REQUERY?
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform