Hi!
I am having a table with auto-inc field for ID
Based upon that table I do have an updatable view
In my app I do create a cursor with same fields as above table/view but without id-field.
I am sure that cursor contains records.
I do select the (buffered) updatable view and try to append from the cursor.
I commit changes to the view
But no records are appende to the view/table.
Any idea?
Do I make basic errors re. the auto-inc field?
-Bart
I am having a table with auto-inc field for ID
Based upon that table I do have an updatable view
In my app I do create a cursor with same fields as above table/view but without id-field.
Code:
CREATE cursor 'curTijdelijk'(NCONT_ID I NOT NULL, ;
NGRAF_ID I NOT NULL, ;
NANTWFORM I NOT NULL, ;
DANTWDAT D NOT NULL, ;
NBEDRAG N(10, 2) NOT NULL DEFAULT 0.00, ;
NBEDRAGSRT I NOT NULL DEFAULT 999, ;
NSTARTJAAR I NOT NULL, ;
NAANTJAAR I NOT NULL, ;
LAG L NOT NULL, ;
COPMERK C(254) NOT NULL, ;
NSTATUS I NOT NULL, ;
CUSER C(20) NOT NULL, ;
TUPDATE T NOT NULL)
I do select the (buffered) updatable view and try to append from the cursor.
I commit changes to the view
But no records are appende to the view/table.
Any idea?
Do I make basic errors re. the auto-inc field?
-Bart