Forms3 - Updating through views

You follow all of the instructions for updating through a view, as described in the Commit-Time Issues section of the Advanced SQL*Forms Techniques book.

Then, you insert a row through the view and commit. The row appears in the table and all is well.

Now, without requerying the data, you decide to modify a field in the newly-inserted row. Result: the on-lock trigger fails with a no_data_found error.

I checked, and the :system.record_status value when the on-lock trigger fires is QUERY. How can there be no_data_found?

If I first requery the block before doing the update, the record is still QUERY when the on-lock trigger is fired, but the trigger does not fail.

We're trapping for "when no_data_found then null" - but that's a workaround, not an answer.

Any answers out there?

Jennifer R. Amon            PHONE: (216) 775-6987
Houck Computing Center        FAX: (216) 775-8573
Oberlin College
Oberlin, OH 44074        INTERNET: bamon_at_ocvaxc.cc.oberlin.edu


_____________________________________________________________________