A script-enabled browser is required for this page to function properly.

CREATE_RECORD Built-in

Description

Creates a new record in the current block after the current record. Oracle Forms then navigates to the new record.

Syntax

PROCEDURE CREATE_RECORD;

Built-in Type restricted procedure

Enter Query Mode no

Parameters

None.

CREATE_RECORD Examples

/*

** Built-in: CREATE_RECORD
** Example: Populate new records in a block based on return
** values from a query
*/
PROCEDURE Populate_Rows_Into_Block( projid NUMBER) IS
CURSOR tempcur( cp_projid NUMBER ) IS
SELECT milestone_name, due_date
FROM milestone
WHERE project_id = cp_projid
ORDER BY due_date;
BEGIN
/* Add these records to the bottom of the block */
Last_Record;
/* Loop thru the records in the cursor */
FOR rec IN tempcur( projid ) LOOP
/*
** Create an empty record and set the current row's
** Milestone_Name and Due_Date items.
*/
Create_Record;
: Milestone.Milestone_Name := rec.milestone_name;
: Milestone.Due_Date := rec.due_date;
END LOOP;
First_Record;
END;


INSERT_RECORD Built-in