re: Record deleted by another user
From: Harvey Mark <IMCEAMS-EARTH_PO1_msmrh>
Date: 1998/04/15
Message-ID: <14D46DF9FC08D111AF8700805F68C0CF1E7635_at_CONNERY>#1/1
>
>
> In a Forms 4.5 form, I populate a block programatically, without using
> the
> block query mechanism. After populating each record in the block, I
> change
> it's status to QUERY_STATUS, so that the block knows that the records
> exist
> already in the database. However, the records cannot be updated
> because of
> the error FRM 40657 - Record changed or deleted by another user.
>
> Anyone know of a way around this?
>
> -----== Posted via Deja News, The Leader in Internet Discussion
> ==-----
> http://www.dejanews.com/ Now offering spam-free web-based
> newsreading
>
Received on Wed Apr 15 1998 - 00:00:00 CEST
Date: 1998/04/15
Message-ID: <14D46DF9FC08D111AF8700805F68C0CF1E7635_at_CONNERY>#1/1
This is usually caused by a locking problem - basically, Oracle attempts to lock the row when an update is made. As you have populated the row programatically, there is no ROWID present, which is what oracle uses to take out a row level lock. Due to the ROWID not being present, Oracle assumes that the row does not exist on the database anymore, hence the message ......deleted by another user. This is a messy situation to find yourself in, you could put code ON-LOCK to null and lock the record yourself using the primary key and then re-write the ON-UPDATE event. However, I would not really recommend going away from the Oracle default processing unless it is really necessary. Mark Harvey.>
> ----------
> From: egardiner_at_jii.com[SMTP:egardiner_at_jii.com]
> Posted At: 11 April 1998 01:12
> Posted To: tools
> Conversation: Record deleted by another user
> Subject: Record deleted by another user
>
>
> In a Forms 4.5 form, I populate a block programatically, without using
> the
> block query mechanism. After populating each record in the block, I
> change
> it's status to QUERY_STATUS, so that the block knows that the records
> exist
> already in the database. However, the records cannot be updated
> because of
> the error FRM 40657 - Record changed or deleted by another user.
>
> Anyone know of a way around this?
>
> -----== Posted via Deja News, The Leader in Internet Discussion
> ==-----
> http://www.dejanews.com/ Now offering spam-free web-based
> newsreading
>
Received on Wed Apr 15 1998 - 00:00:00 CEST