Re: FRM-40654 in Forms 4.5
Date: 1996/10/02
Message-ID: <52u49r$ekh_at_zimmer.CSUFresno.EDU>#1/1
In article <52s3o0$d8c_002_at_news.psi.net>,
Dave Mausner <dmausner_at_brauntech.com> wrote:
>In article <01bbaf16$636f4b00$22f719ce_at_rickfor.scsn.net>,
> "rick forrest" <rickfor_at_scsn.net> wrote:
>>I have a form that calls a stored procedure to do some last minute
>>validation, i.e.
>>just before POST-DATABASE-COMMIT. The stored proc updates the database
>>directly. Consequently, I get the message FRM-40654. Record has been
>>updated
>>by another user, requery to see changes.
>
>it means that the record has a new rowid due to the commit, which disagrees
>with the rowid stored in the form. i suspect that the forms has not yet
>updated the rowid field in memory. before you can touch the record fields,
>you will have to re-read the rowid using the primary keys of the record.
Not quite. The rowid does not change. It means that the stored procedure updated a value in the row, and then when Forms queried the row prior to its update, it found new values had been posted since it first queried the row when the block was displayed.
The only way to prevent the 40654 error is to prevent the validation procedure from updating the row in the database.
Regards,
Steve Cosner
Received on Wed Oct 02 1996 - 00:00:00 CEST