HDR/DTL Update XF310
The type for functions to update a sigle record in the primary table and
related records in the detail table. When executed, it will fetch the
header record and select related
detail records to show them on the form in edit mode. What users can do are updating
the header record and adding/updating/deleting the detail records.
Function sample of HDR/DTL Update
Editting the definition of the function above
Elements to be defined
<
Basic Attributes>
Function Type - Fixed value
Function ID - Fixed and unique value in the system
Function Name - Descriptive expression of the function that is set as the form title.
HDR Table - The main table which record is shown on the form. Possible to define
alternative key to be handled.
Fixed Where - Fixed where criteria integrated into SELECT statement. It has to be
for fields on the primary table. You can use User/Session attributes as
variants(*1).
DTL Table - The table which records to be listed. It has to be
Child or
Refered table of HDR table.
Order By - Order of rows listed. Possible to put fields on the join tables as well
as ones on the HDR table.
Fixed Where - Fixed where criteria integrated into SELECT statement. It has to be
for fields on the primary table. You can use User/Session attributes as
variants.
Adding first if without row - If checked, the funtion will begin with adding row process if with no
row registered.
Panel Size - Select one of options.
Initial Message - Message shown in message area
*1.Specify like USER_ATTRIBUTE:type for
User Attribute(*2). Specify like SESSION_ATTRIBUTE:id for
Session Attbirute(*3). If comparing string values, use single quotation as follows.
DTTHRU >= 'SESSION_ATTRIBUTE:DateFrom' AND DTTHRU <= 'SESSION_ATTRIBUTE:DateThru'
*2.The type can be either of ID, EmployeeNo, Name. For example if you want
to get user ID, define as USER_ATTRIBUTE:ID.
*3.Session attributes can be registered using scripts (typically using
Login Script). If specified attribute with id is not found, Driver will show an error
message. For example if you want to get value of session attribute registered
with id of "Today", define as SESSION_ATTRIBUTE:Today.
<
HDR Fields>
Properties to handle fields on the header table or its join tables. Right-click
on the list to add/delete fields. Drag the row of field to change order.
Select the row to edit attributes as follow.
Table - Table ID and name which owns the field (Non editable)
Type - Table type of the table (Non editable)
Field - Field ID and name (Non editable)
Type - Data type, length and ext-type of the field (Non editable)
Layout Option - If
Vertical selected, it will be layouted on the next row. If
Horizontal selected, it will be layouted right side of the previous field.
Note that each field extends in its height and width with its caption.
This means that some of field areas may cover each other which result in
malfunctions. Typical example is shown on the sample function above. The
portrait field is layouted with 100 pics margin from the previous field.
If with the shorter margin, some fields do not work normally in edit mode
as they cover each other areas.
Width - Width of the field in pixcels. If
*Auto specified, Driver will adjust size according to the caption or data size.
Rows - Height of the field in rows. If
*Auto specified, image field is set as 11 rows and VARCHAR field is set as 2
rows and else as 1 row.
Margin - Margin to the previous field.
Caption - Heading of the field. Select
Field Name or
None or
Value. By specifying SESSION_ATTRIBUTE:id as
Value, you can control column heading dinamically (Note that you can not check
design of the panel on Editor then). By checking
Width Auto-Adjusted, caption width will be adjusted automatically.
Prompt - Setting of the field in edit mode.
None represents direct input.
List Box is to edit with list box. Call ID is to edit by calling function.
Comment - If specified, the value appears on the right side of the field.
<
Columns>
Definitions of columns to be listed which are fields on the primary table
or join tables. Right-click on the list to add/delete columns. Drag the
row of column to change order of columns. Select the row to edit attributes
of the definition as follow.
Table - Table ID and name which owns the field (Non editable)
Type - Table type of the table (Non editable)
Field - Field ID and name (Non editable)
Type - Data type, length and ext-type of the field (Non editable)
Layout Option - If
Vertical selected, it will be layouted on the next row. If
Horizontal selected, it will be layouted right side of the previous column. If
Hidden selected, it will not shown on the row.
Width - Width of the column in pixcels. If
*Auto specified, Driver will adjust size according to the caption or data size.
Rows - Height of the column in rows. If
*Auto specified, image field is set as 2 rows and else as 1 row.
Caption - Column heading. Select
Column Name or
Value. By using SESSION_ATTRIBUTE:id, you can control column heading dinamically
(Note that you can not check design of the panel on Editor then).
Prompt - Setting of the column in update mode.
None represents direct input.
List Box is to edit with list box. Call ID is to edit by calling function.
<
Function Keys>
Definitions of function keys at the bottom of the panel. By exchanging
a specific parameter(DISABLED_BUTTON_LIST), you can disable buttons with
key no(use comma to separate values). Right-click on the list to add/delete
definitions. Max of definitions is 7. Select the row to edit attributes
of the definition as follow.
Position - Position of the button. 0 represents left end and 6 right end.
Function Key No - Function key number(F1-F12) allocated to the button.
Caption - Caption of the button.
Action - Action allocated to the button. Values selectable are "Exit",
"Add Rows", "Call to add rows", "Remove the Row",
"Update", "Delete HDR Record","Output into EXCEL".
Note that what user done for rows are not reflected in the database until
pushing Update button.
<
Where-Used>
The list of functions using this function. Right-click on the row to jump
to the definition.