Skip to content

Latest commit

 

History

History
54 lines (47 loc) · 2.63 KB

data-types.md

File metadata and controls

54 lines (47 loc) · 2.63 KB
Raw

Data Types

XMod Pro data-bound controls enable you to specify the type of data the control will accept. Some controls may limit you to a specific type of data (for instance, a checkbox control might only allow boolean values). The list of valid data types is below:

  • Boolean
  • DateTime
  • Decimal
  • Double
  • Byte
  • Int16
  • Int32
  • Int64
  • Single
  • String

SQL Server Data Type to XMod Pro Data Type Conversion

To make the process of linking your fields up with XMod Pro, we've created a table listing the SQL Server data type and its XMod Pro equivalent, if available. While currently, XMod Pro is designed for SQL Server, it does not support every field type. The goal is to keep XMod Pro loosely coupled so that other databases and data sources can be added in the future. Also, keep in mind that while a certain data type may have an XMod Pro equivalent, you should ensure that the values accepted from your users do not exceed the limitations of the data type. For instance, if you choose the NChar datatype in SQL Server, you should use the String XMod Pro data type. However, you need to ensure the text entered falls within the limits of the NChar field (4,000 characters for SQL Server 2005). We have noted limitations for some data types.

SQL Server Data Type XMod Pro Data Type
BigInt Int64
Binary Not Supported
Bit Boolean
Char String (subject to Char size limits)
Date Date (supported as of XMod Pro 3.1)
DateTime DateTime
DateTime2 DateTime (supported as of XMod Pro 3.1)
DateTimeOffset Not Supported
Decimal Decimal
Float Double
Image Not Supported
Int Int32
Money Decimal. Do not include currency symbols (i.e $) in value.
NChar String (subject to NChar size limits)
NText String
NVarChar String (subject to NVarChar size limits)
Real Single
SmallDateTime DateTime (subject to SmallDateTime size limits)
SmallInt Int16
SmallMoney Decimal (subject to SmallMoney size limits). Do not include currency symbols (i.e $) in value.
Structured Not Supported
Text String
Time Use SQL DateTime data type instead)
Timestamp Not Supported
TinyInt Byte (supported as of XMod Pro 3.1)
Udt Not Supported
UniqueIdentifier String (supported as of XMod Pro 3.1) Ensure your data is formatted accordingly
VarBinary Not Supported
VarChar String (subject to VarChar size limits)
Variant Not Supported
Xml String (supported as of XMod Pro 3.1)