Dear all,

We have a business process where the user locks a transaction by approving/posting it. Once the transaction is locked, no one should update or delete it but should be able to read it. However, unlocked transactions should be available for update and delete operations. One transaction may consist of one Master row and multiple detail and detail/detail tables. When locked the Master row should be blocked for Updating and Deleting and detail and detail/detail tables should be blocked for Creating, Updating and Deleting.

We are able to do it in Oracle Forms simply by applying Insert_allowed, update_allowed and Delete_allowed properties of the Blocks(stands for Tables and Datasource in formspider). When the cursor moves into a posted/approved Master row, a procedure is called to lock the master row and all the detail and detail/detail tables. This procedure sets the update_allowed etc. to False. Similarly, when the cursor moves into a un-posted/un-approved Master row, update_allowed etc. is set to True to all concerned tables.

We require the same mechanism in formspider. We have checked the API_DATASOURCE manual but did not find any APIs to dynamically Insert/Update/Delete datasource at runtime.

If there is any other alternatives, kindly let me know.



asked 22 Apr '14, 02:05

grajan777's gravatar image

accept rate: 10%

Hi George,

The Grid has an attribute called editableColumn. This attribute points to a column in the datasource which can determine whether a particular row in the grid is editable or not. You can change the value of this column for each row in the Grid. Y sets a row as editable N sets it as not-editable.

You can read more about this in this tutorial:

Kind Regards,


answered 22 Apr '14, 08:51

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
accept rate: 15%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 22 Apr '14, 02:05

Seen: 2,132 times

Last updated: 22 Apr '14, 08:51

© Copyright Gerger 2017