Supported Data Types

Supported Data Types

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

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.