RASDC_FIELDSONBLOCK

Fields on block (RASDC_FIELDSONBLOCK)

List of fields on block. All fields on block are actually variables (table of pls_integer). Then you have variables directly on form. These variables are simple types.

Block elements

Filter where you choose block or form (F) level.

Block elements. Described in [RASDC_BLOCKSONFORM]

Field elements

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

Basic settings

Label	Description
Field	Name of field must contain only letters, numbers, sign '_' and must be started with letter.
Order	Order of fields on form. Based on these values blocks are ordered.
Type	C - Varchar2, N - Number, D - Date (time is date type), R - ROWID, L - CLOB
Format(D,N)	Format of date or number fields. Described in [RASD_RESERVED].

Settings for data manipulation

These fields are checked when block is checked DB block = Y.

Label	Description
PK	Primary key. Check if field is primary key. Based on that update and delete statements are prepared.
S	Select. Check if this is field from SQL.
I	Insert. Based on that insert statement is formed.
U	Update. Based on that update statement is formed.
D	Delete. If all values of fields checked - D are delete the data in table will be deleted.
Mn.	Mandatory. Checks if value of field exists before insert and update.
In.	Do insert. If all values of fields checked - In. exists the insert in table will be done.
L	.
Default	Default value of field if the value is null. Constanst must be in ''. Sample 'My data' or number 1234.99 or date to_date('12.12.1212','dd.mm.yyyy') or any variable.
GV	Global variable. Activate GV for your variable. It name is your_variable#GV. This varable has value of init status and it is not changed during progrma executing.

Settings for GUI

Label	Description
VS	Visual Setting. Vhen activated you have new properties for current variable. You can set them in triggers.
UI	Check if you would like to have filed on GUI interface.
UI Field	Name of GUI field - element name in HTML
Label	Label of field. Can be user <%= %>, <% %> syntax.
Type	Type of field on GUID. Some elements (in name is LOV) can be linked with list of values (LOV). Some elements you can connect with Link (A, IMG, ...) When you put link to SUBMIT field you can put in Link your own javascript or conection submit vwith submitted values. Use javascript function if (cMF()== false){return} to chech mandatory fields of form (use cMF+block name for block validation).

Settings for list of values - LOV

Label	Description
Link/LOV	Select the LOV from list and link it to LOV element. LOV's you modify in [RASDC_LINKS].

Field elements on form (F)

These fields are treated slightly diferent ten fields on blocks. First in PL/SQL code these fields are simple types. Fields on blocks are all table types.

Go back to [Documentation]