Re: Forms3 - Updating through views

In article <bamon-100294152121_at_amon.cc.oberlin.edu>, bamon_at_ocvaxc.cc.oberlin.edu (Jennifer R. Amon) wrote:

> 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?

For those of you who saw this message before I cancelled it, I found it. Stupid mistake. Sorry.

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
_____________________________________________________________________