RASDC_BLOCKSONFORM

Form XYZ (RASDC_BLOCKSONFORM)

List of blocks (sections) on the form.

Form elements

Red labels are elements used on GUI.
Blue labels are elements used in logic.

Label	Description
Form	Name of form must contain only letters, numbers, sign '_' and must be started with letter.
Version	Version of form
Name	Display name of the form. In name you can use <%= %> or <% %> syntax.
Post action	URL of action when the form is submitted.
Messages	Where you would like to se messages. At the top or bottom.
UI Template	Template for you GUI. This is set into POST_INITIALIZATION trigger
	Refernece form / Send to GIT / Download PL/SQL code / Form triggers / Form fields / Documentation

Block elements

Blocks are ordered by values of Order on fields. They are ordered by min value of Order of fields in the block.

Label	Description
Block	Name of block must contain only letters, numbers, sign '_' and must be started with letter.
Table, View, Synonym	List of DB objects
Rows	Number of rows in table (0 - all from DB, 1 - one, ...). If Rows are 1 and Bck / Fwd not checked labels of fields on form are left of fields othervise labels are on top. If Bck / Fwd is not checked then Rows value is 0.
Empty rows	Number of empty rows added to the bottom of table
DB block	Check if the block is DB block (if yes then Select, Insert, Update, Delete statements are prepared)
RowID	Check if you update records with ROWID (if yes rowid field must exists)
Bck / Fwd	Check if you would like navigation buttons (backward / foreword)
Clear	Check if you would like clear button
Block name	Display name of the block. In name you can use <%= %> or <% %> syntax.
Structure	The block can be prepared with TABLE or DIV elements.
Field lab.	Where you would like to have labels. On the top or on the left.
	SQL editor / Block triggers / Copy block / Delete block / Documentation / Detail information of the block

SQL editor

Screen preview when you press download PL/SQL code

Go back to [Documentation]