OraFAQ Forum: Forms » Update data of IOT from d2k

Home » Developer & Programmer » Forms » Update data of IOT from d2k (oracle 9.0.2.1 D@K 6.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Update data of IOT from d2k [message #309405]

Thu, 27 March 2008 06:10

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..

Report message to a moderator

Re: Update data of IOT from d2k [message #309439 is a reply to message #309405]

Thu, 27 March 2008 08:13

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.

Report message to a moderator

Previous Topic:	how to print a form with inserted data
Next Topic:	how to put background image in form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 10:24:42 CDT 2024