RASD_RESERVED

Reserved words / restrictions

• Restricted field names for generated programs are set RASD enviorment in package RASD_ENGINE?? and you can change them:

c_rs rasd_fields.fieldid%type := 'RS'; --field record status
c_rid rasd_fields.fieldid%type := 'RID'; --field row id
c_recnum rasd_fields.fieldid%type := 'RECNUM';--field for current number of block record
c_page rasd_fields.fieldid%type := 'PAGE'; --field for page
c_message rasd_fields.fieldid%type := 'MESSAGE'; -- field message
c_action rasd_fields.fieldid%type := 'ACTION'; -- field action
c_restrestype rasd_fields.fieldid%type := 'RESTRESTYPE'; -- field for REST response type
c_fin rasd_fields.fieldid%type := 'FIN'; -- field name for returninga parameters from LOV's

In generated programs some of them have block name postfix (RECNUMB10).

GBUTTONSRC -- search button action
GBUTTONRES -- reset button action
GBUTTONSAVE -- save-commit button action
GBUTTONBCK -- back button action
GBUTTONFWD -- forward button action
GBUTTONCLR -- clear button action

Name of BLOCK must not be the same as name of FORM

• Supported data types:

Block data types:
type rtab is table of rowid index by binary_integer;
type ntab is table of number index by binary_integer;
type dtab is table of date index by binary_integer;
type ctab is table of varchar2(4000) index by binary_integer;
type cctab is table of clob index by binary_integer;
type itab is table of pls_integer index by binary_integer;

Form data tayps: rowid, number, date, varchar2(4000), varchar2(32000), pls_integer

• <%= %> or <% %> syntax

In same places you can use <%= %> or <% %> syntax where you can write PL/SQL code.

Sample:

• <%= your_variable %> is the same as <% htp.p(your_variable); %>

• <% if 1 = 1 then htp.p('Print TRUE'); else htp.p('Print FALSE'); end if;%>

• **Date, number formats **

In field for formatting you can us all PL/SQL Date or Number formats.

In package RASD_CLIENT you have defined default values for:

• Transformation between PL/SQL type and DateTime Calendar (JQuery UI).
• Signs for decimal or thousand (Number) (Default decimal=. thousand=,)
• Default date format for all applications (default YYYY-MM-DD)

Sample used in programs:

• 'dd.mm.yyyy'
• 'yyyy-mm-dd'
• '999G999G900D00' - always use signs D and G for D-decima, G-ground positions.
• '00000D000'
  rasd_client.date_format - constant

Back to [Documentation]