Supported Data Types

Supported Data Types

The supported data types for SQL include bigint, binary, bit, char, date, datetime, decimal, float, int, money, nchar, numeric, nvarchar, real, smalldatetime, smallint, smallmoney, tinyint, uniqueidentifier, varbinary, varchar, and xml. This is applicable for database queries, stored procedures, and list lookups.

BigInt, Decimal, Float, and Money data types in the List control is limited to the range -999999999999999 to 999999999999999. This limited range is due to the limitation of a number in the underlying JavaScript technology used in Forms.

SmallMoney data types in the List control is limited to the range -214748.3648 to 214748.3647. Also, the Number control in the associated form generated by the List is limited to 2 decimal places. So, the Number control range would be from -214748.36 to 214748.36.

The supported data types for Oracle include bfile, binary_double, binary_float, blob, char, clob, date, float, interval day, interval year, long, long raw, nchar, nclob, number, nvarchar2, raw, rowid, urowid, varchar, and varchar2. This is applicable for database queries and stored procedures.

Note:
- Each user in the "Manager list" will have a unique id but can have similar names.
- Lookup control has properties Value column and Display column.
- The value for the Value column will be persisted in the form instance XML of the "User list". However, the value for the "display column" is retrieved from the "Manager list" based on the value of the Value column when the form is rendered. Hence its mandatory that the Value column selected for the lookup control has unique values.
- For the Display column, it is recommended to use the String data type. In the case of Database Lookup, the Display column should be of a data type that can be implicitly converted to a string during execution. For other types of lookups, consider using general data types such as String, Number, or DateTime. Avoid using data types like Binary, Large Text Columns, or Arrays. In summary, a String data type is the preferred choice for the Display column.