Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1585 - Update Conflict
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00801449
Message ID:
00802276
Views:
35
Hi Kevin,

I followed your suggestion. Here is exactly my setup.
* mydbase!Table1.dbf, fields are below
* pkid Integer autoinc, pkid is the primary key
* vendno char(6)
* invno char(15)
* invamt N(12,2)
*
* lv_view1 as select pkid,vendno,invno,invamt from mydbase!table1
***** pkid is checked for the key and not updatable
***** vendno,invno,invamt are updatable
* lv_view2 as select pkid,invno,invamt from mydbase!table1 ;
* where vendno==?vp_vendno
***** pkid is checked for the key and not updatable
***** invno,invamt are updatable

Below is exactly what I did in VFP command window.

open database mydbase
USE lv_view1
append blank
REPLACE vendno WITH "ACC123"
REPLACE invno WITH "TESTINV"
REPLACE invamt WITH 1500.00
TABLEUPDATE()
REQUERY()
BROWSE LAST * I saw the record
USE lv_view2 ALIAS "view2"
BROWSE * entered "ACC123" when asked for vp_vendno
* press enter and I saw my new record
REPLACE invno WITH "TESTING"
REPLACE invamt with 2000.00
TABLEUPDATE()
REQUERY()
BROWSE LAST * I saw the updated record and no error displayed

In my application, I am passing the bizobj of lv_view1 as the toCallingFormListObj when I call my clistobjeditform subclass form. Then I am using the built-in code of MM in the cmdOK.click(). When I go back to the calling form, I requery the bizobj of lv_view2 which is the rowsource of my grid. The user may highlight any record in this grid to edit. Then I use lv_view2 bizobj to edit invoice record. But this is the part where I get the error.

Thanks a lot again for any help.

Nerissa
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform