how to append a record to an updatable view?

[Nifrabar]

Hi!

I do have in a data-form an updatable view with an 'ID'-field based upon the auto-inc ID-field of a table.
What's best way to append a record to that view?
I did include into my save-routine the 'test for conflicts' as described in 1001things.
As there is a test with curval() ,oldval() and userval() it happens that we are trying to update the table with null-values which generates errors.

Any suggestion how to deal with this?

-Bart

 

[Nifrabar]

In addition, maybe a solution will be:
Firstly create a new rcord in the basetable, requery the updatable view, go to the appended record and modify according the data for the new record.
Is that a good or bad way to achieve the result.
I have to keep in mind that it is unwanted to have buffered basetables and bufferd views fron these tables in same DE.
Or wouldnot it be necessary to have the table buffered?
-Bart

 

[MarciaAkins]

As there is a test with curval() ,oldval() and userval() it happens that we are trying to update the table with null-values which generates errors.

Any suggestion how to deal with this?

See NVL() in the on-line help.

Marcia G. Akins

http://www.TightlineComputers.com