General information
Category:
The Mere Mortals Framework
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only