Has title

Enables or disables the title above the Detail View part.

tmpl.DetailView.HasTitle as L

Title

The title of the Detail View part.

tmpl.DetailView.Title as C

Show row labels

Indicates whether to show or hide row labels.

tmpl.DetailView.show_row_labels as L

Allow delete

Determines whether the user can delete records.

tmpl.DetailView.edit.allow_delete as L

Allow update

Determines whether the user can make changes to existing records.

tmpl.DetailView.edit.allow_update as L

Allow insert

Determines whether the user can insert new records.

tmpl.DetailView.edit.allow_insert as L

Delete security level

Sets the user's minimum security level required to delete records.

tmpl.DetailView.edit.DeleteSecurityLevel as N

Update security level

Sets the user's minimum security level required to edit records.

tmpl.DetailView.edit.UpdateSecurityLevel as N

Insert security level

Sets the user's minimum security level required to insert records.

tmpl.DetailView.edit.InsertSecurityLevel as N

Pre-fetch data for Detail View

If you choose this option, it will take a little longer for the page to display initially, but then the Detail View will display immediately (without a server round trip). Your browser will use JavaScript to populate the Detail View from the pre-fetched data.

Note : This feature does not support link and image type controls in the Detail View.

tmpl.DetailView.PopulateUsingJavaScript as L

Only show Detail View on request

Specifies whether to hide the detail view form until you select to edit a record.

tmpl.DetailView.OnlyShowOnRequest as L

Close Detail View after submit

Specifies whether to hide the detail view after a submit.

tmpl.DetailView.CloseAfterSubmit as  L

Hide Grid part when Detail View is visible

Specify whether to hide the grid when the detail view form is visible.

tmpl.DetailView.HideGridIfDetailViewIsVisible as L

Detail View has a 'Close' link

Specifies whether the detail view form has a close link.

tmpl.DetailView.HasCloseLink as L

Close Detail View link label

Specifies the label of the close link.

tmpl.DetailView.CloseDetailViewLinkLabel as C

Only validate edited fields

Define whether to validate all fields or only edited fields.

Template for reporting errors

Define the template for reporting errors.

Instruction message

Display this message if an error occurs.

Error page 'Row' heading

Specifies the column title for the "Row Number" column.

Error page 'Error' heading

Specifies the column title for the "Error" column.

Delete record button label

The label of the Delete button (default: "Submit").

tmpl.DetailView.DeleteRecordButtonLabel as C

Save record button label

The label of the Save button.

tmpl.DetailView.SaveRecordButtonLabel as C

Add record button label

The label of the Add button.

tmpl.DetailView.AddRecordButtonLabel as C

Add new records link label

The label of the New Record button.

tmpl.DetailView.AddNewLinkLabel as C

Has Cancel button

Specifies whether there is a Cancel button.

tmpl.DetailView.edit.has_Cancel_button as L

Cancel button label

The label of the Cancel button (default: "Cancel").

tmpl.DetailView.edit.cancel_button_text as C

Confirm before submit - Add

Specifies whether to display a confirmation dialog to the user before adding a record to the database.

tmpl.DetailView.edit.add_confirm_before_submit as L

Confirmation message - Add

The default add record confirmation message.

tmpl.DetailView.edit.add_confirm_before_submit_message as C

Confirm before submit - Update

Specifies whether to display a confirmation dialog to the user before changing a record in the database.

tmpl.DetailView.edit.save_confirm_before_submit as L

Confirmation message - Update

The default update confirmation message.

tmpl.DetailView.edit.save_confirm_before_submit_message as C

Confirm before submit - Delete

Specifies whether to display a confirmation dialog to the user before deleting a record in the database.

tmpl.DetailView.edit.delete_confirm_before_submit as L

Confirmation message - Delete

The default delete confirmation message.

tmpl.DetailView.edit.delete_confirm_before_submit_message as C

'Delete' button target page

The page to display after deleting a record. Specify "<Self>" for the current page.

'Save' button target page

The page to display after updating a record. Specify "<Self>" for the current page.

'Add' button target page

The page to display after adding a record. Specify "<Self>" for the current page.

Check for write conflicts

Specifies whether, before saving changes to a record, Alpha Five should make sure that no other user has saved changes to the same record.

Write conflict check type

Specifies the write conflict check type. The options are:

1 - Check all fields on the form for write conflicts

2 - Check only dirty fields (i.e. fields with changes) for write conflicts.

Show update commands

Specifies whether to show the SQL or Xbasic statements that are generated to perform INSERT, UPDATE, or DELETE commands.

Execute update commands

A useful debugging technique. Sets a mode whether to show the update commands, but not actually execute them.

Above detail view part

HTML text to place above the detail view.

tmpl.EditRegion.DetailView.Top as C

Below detail view part

HTML text to place below the detail view.

tmpl.EditRegion.DetailView.Bottom as C

Left of detail view part

HTML text to place to the left of the detail view.

tmpl.EditRegion.DetailView.Left as C

Right of detail view part

HTML text to place to the right of the detail view.

tmpl.EditRegion.DetailView.Right as C

Style Sheet

The name of the CSS style sheet to use.

tmpl.style_name as C

Detail View

Indicates whether there is a detail view.

tmpl.DetailView.Has_DetailView as L

Detail View Linking Field

The field that provides the selects the record to display in the detail view.

tmpl.DetailView.linkfield as C

Is the detail view editable

Specifies whether the records displayed in the detail view are editable.

tmpl.DetailView.editable as L

Control type

Sets the type of the control.

• AdvancedButton

• CheckBox

• DropDownBox

• Image

• Label

• Link

• RadioButton

• TextArea

• TextBox

tmpl.DetailField_Info[N]

.controltype as C

Display Format

This expression formats the data after it has been entered into the field. Click to display the Display Format dialog box. This property should be set to one of the following values:

• Null

• An Xbasic expression that returns a character value. The expression should use <value> as Placeholder for the field value, as in the following example: f_upper(<value>).  Optionally, click Select Pre-Defined Format to select a format from the Pre-Defined Formats dialog box.

tmpl.DetailField_Info[N]

. DisplayFormat as C

Display unformat

If you set a Display Format, you may also place a character expression in the this field. This expression reformats the data before it is stored in the database.

tmpl.DetailField_Info[N]

. DisplayUnFormat as C

Choices

Click to define the true and false choices set by the check box. Refer to the Define Choices for details.

Orientation

The orientation of the label. The choices are:

• "Horizontal"

• "Vertical"

In – line style

Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details.

Style control if error

Specifies whether to apply a second style to the field if a validation error occurs.

In – line style for errors

Specifies style attributes that are used when a validation error occurs. Click to define the In-line style. Refer to the Style Editor for details.

Not in list rule

Specifies the value to set if the user input does not match a specified choice. The options are:

• "First Entry" - use the first entry in the list

• "Null" - set the field to NULL

• "Do Nothing" - accept the user input

Choices

Defines the choices the appear in the control. Click to define the true and false Choices set by the check box. Refer to the Define Choices for details.

Height

Set the height of the label in lines. The default is 1, which produces a combo box. Values larger than 1 produce a list box.

In – line style

Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details.

Style control if error

Specifies whether to apply a second style to the field if a validation error occurs (V6 only).

In – line style for errors

Specifies style attributes that are used when a validation error occurs. Click to define the In-line style. Refer to the Style Editor for details (V6 only).

Not in list rule

Specifies the value to set if the user input does not match a specified choice. The options are:

• "First Entry" - use the first entry in the list

• "Null" - set the field to NULL

• "Do Nothing" - accept the user input

Image name

The name of the image to display.

tmpl.DetailField_Info[N]

. Image.Imagename as C

In – line style

Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details.

tmpl.DetailField_Info[N]

. Image.InLineStyle as C

Text description

The text description of the image.

tmpl.DetailField_Info[N]

. Image.Alt as C

Is Hyperlink

Is the image a hyperlink?

tmpl.DetailField_Info[N]

. Image.IsHyperLink as L

Hyperlink target

The page to display when the link is clicked.

tmpl.DetailField_Info[N]

. Image.hyperlinkTarget as C

Target frame

The name of the window that will display the new page.

tmpl.DetailField_Info[N]

. Image.hyperlinkTargetFrame as C

In – line style

Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details.

tmpl.DetailField_Info[N]

. Label.InLineStyle as C

Link type

The options are:

• "Explicit" - data in field is the Link URL (e.g. http://www.asc.com)

• "Computed" - link is constructed from data in the field (e.g. data in field is "BOLID", and the constructed link becomes form.a5w?customer_id=BOLID)

tmpl.DetailField_Info[N]

. Link.Type as C

Display value

The default is Null. The options are:

• Null - the field displays the actual value in the field.

• "{Fieldname}" - displays value in the selected field for the current record.

• "explicit string" - displays the "explicit string"

tmpl.DetailField_Info[N]

. Link.DisplayValue as C

Target window

The default is "Explicit". Defines where to display the linked page. The default is Null. The options are:

• Blank (opens in a new window)

• "Explicit"

• "WindowName" (e.g. "Window2")

• "_blank"

• "_parent"

• "_self"

• "_search"

• "_top"

tmpl.DetailField_Info[N]

. Link.TargetWindow as C

Target page

The default is Null. Defines the page to open. The options are:

• "Computed"

• "Blank"

• Null - the current .A5W page

• an explicit .A5W page

tmpl.DetailField_Info[N]

. Link.TargetPage as C

Clear Parameters

V6

The default is .F. . Specifies whether the target URL preserves existing parameters.

tmpl.DetailField_Info[N]

. Link.ClearParameters as L

Choices

Click to define the true and false choices set by the check box. Refer to the Define Choices for details.

In – line style

Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details.

Orientation

The orientation of the label. The choices are:

• "Horizontal"

• "Vertical"

Type

Select the Type of radio buttons you will have. The options are:

• "Static" - Predefined

• "Dynamic" - Computed (for example, by looking up information in a table)

Maximum choices

If you specified "Dynamic" radio buttons, enter the maximum number of choices to show.

Style control if error

Specifies whether to apply a second style to the field if a validation error occurs.

In – line style for errors

Specifies style attributes that are used when a validation error occurs. Click to define the In-line style. Refer to the Style Editor for details.

Hide row

Hides the column or row that would contain this field. You might choose to hide the field if it was displayed in a free-form layout.

tmpl.DetailField_Info[N]

. Column.Hide as L

Row heading

The label that identifies the column.

tmpl.DetailField_Info[N]

. Column.Heading as C

Row label in-line style

Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details.

tmpl.DetailField_Info[N]

. Column.LabelInLineStyle as C

Row label position

V6

The position of the label in relationship to the control. The options are:

• "Left"

• "Right"

• "Above"

• "Below"

tmpl.DetailField_Info[N]

.Column.LabelPosition as C

Label prefix

Specify HTML text or the path to and name of an image to be displayed to the left of the column heading.

tmpl.DetailField_Info[N]

. Column.Heading_Left as C

Can sort

Specifies whether the grid will be sorted when the user clicks on the column heading.

Sort field

Specify the field(s) to sort on when user clicks on the column title. Put commas between field names.

Freeform layout

V6

Specify if this column or row should display just this field, or allow a free-form layout. The options are:

• "Freeform"

tmpl.DetailField_Info[N]

.Column.Type as C

Freeform template

V6

Click to display the Freeform Column Layout dialog box to define the fields and formats to display in this grid cell.

tmpl.DetailField_Info[N]

.Column.FreeFormTemplate = <<%html%

' code here

%html%

Cell in-line style

Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details.

tmpl.DetailField_Info[N]

. Column.InLineStyle as C

Bubble Help Text

V8

Optionally, set an initial value for the control to display.

tmpl.Variable_Info[N]

.BubbleHelp as C

Label Bubble Help Text

V8

Optionally, set an initial value for the control to display.

tmpl.Variable_Info[N]

.BubbleHelpLabel as C

Break Type

V8

When the number of layout columns is greater than 1, this command can be used to position controls. The options are:

• "None"

• "Break before"

• "Break after"

• "Break before and after"

tmpl.Variable_Info[N]

.Breaktype as C

Column Span

V8

When the number of layout columns is greater than 1, this specifies the number of columns to group together..

tmpl.Variable_Info[N]

.nCols as N

Security groups

V8

The names of the groups permitted or denied access to this field.

tmpl.Variable_Info[N]

.Column.SecurityGroups as C

Rows

Sets the height of the control by specifying the number of rows.

tmpl.DetailField_Info[N]

. TextArea.Rows as N

Columns

Set the width of the control by specifying the number of columns.

tmpl.DetailField_Info[N]

. TextArea.Cols as N

In – line style

Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details.

tmpl.DetailField_Info[N]

. TextArea.InLineStyle as C

Size

V6

Sets the width of the field in characters.

tmpl.DetailField_Info[N]

. Textbox.Size as N

MaxLength

V6

Sets the maximum length of the user's input in characters.

tmpl.DetailField_Info[N]

. Textbox.MaxLength as N

In – line style

V6

Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details.

tmpl.DetailField_Info[N]

. Textbox.InLineStyle as C

Style control if error

V6

Specifies whether to apply a second style to the field if a validation error occurs (V6 only).

tmpl.DetailField_Info[N]

. Textbox.StyleFieldIfError as L

In – line style for errors

V6

Specifies style attributes that are used when a validation error occurs. Click to define the In-line style. Refer to the Style Editor for details (V6 only).

tmpl.DetailField_Info[N]

. Textbox.ErrorInlineStyle as C

Updateable

Enables or disables the ability to edit the value of the field.

tmpl.DetailField_Info[N]

. Updateable as L

TableAlias

The alias of the table providing the data.

tmpl.DetailField_Info[N]

. Table_Alias as C

Table

Path and name of the table providing the data.

FieldToUpdate

The name of the table field that is bound to the control.

tmpl.DetailField_Info[N]

. FieldToUpdate as C

Server

Click to define the specify the Xbasic to run to when the form is submitted.

events.server.validate = <<%code%

' code here