Display Tab

• Align
• Length
• SQL to Display

This allows you to create a non-editable text field which is populated by an SQL query. (Hash Variables are allowed here: see Appendix for Hash Variables)

Align

Option Left/Right/Centre. This will align the text to the selected option.

Length

This sets the width of the Display field.

SQL to Display

This is the SQL statement that would retrieve the data to display in the Display Object (Hash Variables are allowed here: see Appendix for Hash Variables). e.g. SELECT cus_last_name FROM customer WHERE customer_id = '#id#' ''

This SQL would retrieve a customer’s last name from the customer table and display it in the Display field.

---