How to deal with FRM-40654 ?
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