In Array Tab

• Default Value Sql
• Length
• Stop Blanks
• Stop Duplicates
• SQL

The InArray Object is a text field that can only contain values from an SQL result set.

You would use an InArray Object in a situation where you don’t need the User to see all the available options, but they are required to type a correct or valid entry.
i.e. a 24 hour clock, where a User would have to input a time within the closest 15 minutes.

The InArray Object can be populated from a field within a table or from a pre-constructed list. In the above situation, with a 24 hour clock, you would have a table of all valid time entries, and a SQL query that would select all those values.

If the User inputs a value that is not in the SQL result set, an alert will stop them.
e.g. Must be between 0000 and 2345

For more information refer to Lists

Default Value Sql

The SQL statement that sets the Default value when the InArray Object is displayed. This is done by selecting the value of the InArray Object.
e.g. The following SQL would set the default InArray Object value to “1200” (If “1200” existed in the result set of the SQL used to populate the InArray Object).

SELECT ‘1200’

Length

This sets the width of the InArray Object.

Stop Blanks

This stops the User leaving the InArray Object blank.

Stop Duplicates

This stops the User from typing a value that is already saved in the database.

SQL

The SQL statement that selects the result set used to validate the InArray Object.
The following SQL statement would populate the InArray Object with a 24 hour clock result set.
(If ‘times’ was a table with 15 minute increments all the way from 0000 to 2400) e.g. SELECT times_id FROM times ORDER BY tim_time

---