Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

problem with apend from

Status
Not open for further replies.

Nifrabar

Programmer
Mar 16, 2003
1,343
NL
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.
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 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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top