Home » Developer & Programmer » Forms » Update data of IOT from d2k (oracle 9.0.2.1 D@K 6.)
Update data of IOT from d2k [message #309405] Thu, 27 March 2008 06:10 Go to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

Hello sir,

I have one table organized by index.
This table is used by the D2K form for insert, update, delete activities.
When i try to update table's data from this form, it gives me the error
FRM-40657 with message "record changed or deleted by other user"
But there is no other application or user using this table or it's data.

Please help me, why it is happening and how to solve from this situation..

Re: Update data of IOT from d2k [message #309439 is a reply to message #309405] Thu, 27 March 2008 08:13 Go to previous message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

Hi friends,

I got the solution. Smile

fix following and you will get the IOT working in D2k nicely..

1. Set block property 'Key Mode' to 'Updateable' on the block related to the
index organized table.

2. Set block property 'Enforce Primary Key' to 'Yes'

3. Set item property 'Primary Key' to 'Yes' for all primary key items.
Previous Topic: how to print a form with inserted data
Next Topic: how to put background image in form
Goto Forum:
  


Current Time: Wed Dec 07 06:46:09 CST 2016

Total time taken to generate the page: 0.19417 seconds