THE_STATUSES

GET_RECORD_PROPERTY built-in
=====================
Description
Returns the value for the given property for the given record number in the given block.  The three
parameters are required.  If you do not pass the proper constants, Form Builder issues an error.  For
example, you must pass a valid record number as the argument to the record_number parameter.
Syntax
FUNCTION GET_RECORD_PROPERTY
  (
record_number 
NUMBER,
   block_name    
VARCHAR2,
   property      
NUMBER);
Built-in Type   unrestricted function
Returns  VARCHAR2
Enter Query Mode  yes
Parameters
record_number Specifies the record in a block for which you want property information.
The number must correspond to a record number.
block_name Specifies the block containing the target record.
property Specifies the property for which you want the current state. One property
constant is supported: Status.
STATUS returns NEW if the record is marked as new and there is no
changed record in the block.  Returns CHANGED if the record is marked
as changed.  Returns QUERY if the record is marked as query.  Returns
INSERT if the record is marked as insert.
Usage Notes
The following table illustrates the situations which return a NEW status.
Record
Status
Block
Status
Form
Status
Created record with no modified
fields
NEW <N|Q|C> <N|Q|C>
...and all records in current
block are NEW
NEW NEW <N|Q|C>
...and all blocks in current form
are NEW
NEW NEW NEW