How to deal with FRM-40654 ?

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Tue, 27 Jul 2004 16:09:18 +0200
Message-ID: <2mn67sFof50uU1_at_uni-berlin.de>



Hello,

there are times when I stumble upon some basic problems with Forms ...

In a Forms database block - showing only one record, I make some changes to a record
and save it by COMMIT;
So far so good, shows me "FRM-40400: Transaction completed". System mode is 'NORMAL', record_status is 'QUERY' as expected.

Next second I make another change to the same record and try to save. System mode is 'NORMAL', record_status is 'CHANGED' as expected. But _this time_ I get FRM-40654: Another user has changed this record bla bla.
Says that I should requery the data and so on ... I can of course do this, but: _why_ ?

The "other" user is nobody else but my little lot - actually I am the only one doing DML
on the table, I am still testing my Form.

What makes me wondering even more then:
I have another database block in the form, showing 6 records on another tab page,
does not have this behavior,
I can change those records
over and over without requerying them.
Checking the properties of both makes no difference except of course source/target tables or names.

[Quoted] Makes me scratching my head ... vot iss ziss ? I does not make sense.

Any comments are greatly appreciated.

I think, this is not only a question about my (desupported) Forms version, this is more basic, that is: my lack of understanding. Oracle Forms5 on Windows client, (which I know how comments on that would be ...)
OEE 8.1.7.3 on an AIX server.

TIA, Jan Received on Tue Jul 27 2004 - 16:09:18 CEST

Original text of this message