[Webinar] Streamline your web hosting managementRegister Today

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

How do I test if a block has a new record?

I want to allow modifications to a certain key field in another block only on condition that the record in another block is a new record that so far has not been saved.  How do I test if this is so in PL/SQL?
0
desmondg
Asked:
desmondg
1 Solution
 
Helena Markováprogrammer-analystCommented:
IF Get_Record_Property(1,'another_block',STATUS) = 'NEW' THEN ...
0
 
sapnamCommented:
Syntax of Get_record_property

GET_RECORD_PROPERTY(record_number, block_name, property);

So I think we should code this as

IF Get_Record_Property(:SYSTEM.CURSOR_RECORD,'another_block',STATUS) = 'NEW'

0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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