Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 624
  • Last Modified:

how do i lock a record in data block

hi experts..
                     i m new to oracle form builder.. can anybody help me i locking records in a data block in oracle forms..

in my case there is a detail block i want to lock some records under some conditions.. means user will not be able to update those particular records or u can say rows in detail block..

lock_record will help me??

regards..
0
livinglive1
Asked:
livinglive1
1 Solution
 
navpakCommented:
Hi,
Where I understand you want to lock complete row in grid.

Please try this solution it will work for your requirements and run this statement in a loop

"set_item_INSTANCE_property('item_id',CURRENT_RECORD, UPDATE_ALLOWED, property_false);"

Regards
 
0
 
livinglive1Author Commented:
This is the best solution i ever seen...!!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now