Reference tables

Table 33: OpenAccess data types and .NET type when adding value
SQL Type	Data Type – use with API calls	.NET Data Types
BIGINT	XO_TYPE_BIGINT	long
BINARY	XO_TYPE_BINARY	byte [ ]
BIT	XO_TYPE_BIT	bool
CHAR	XO_TYPE_CHAR	StringBuilder – string of characters
DATE	XO_TYPE_DATE	DateTime – create this object using DateTime(year, month, day)
DOUBLE	XO_TYPE_DOUBLE	double
FLOAT	XO_TYPE_FLOAT	double
INTEGER	XO_TYPE_INTEGER	int
LONGVARBINARY	XO_TYPE_LONGVARBINARY	byte [ ]
LONGVARCHAR	XO_TYPE_LONGVARCHAR	StringBuilder – string of characters
NUMERIC	XO_TYPE_NUMERIC	StringBuilder – a string with a decimal point. Does not have to be padded for exact precision and scale specifications.
REAL	XO_TYPE_REAL	float
SMALLINT	XO_TYPE_SMALLINT	short
TIME	XO_TYPE_TIME	DateTime – create this object using DateTime(hour, minute, second, fraction)
TIMESTAMP	XO_TYPE_TIMESTAMP	DateTime – create this object using DateTime(year, month, day, hour, minute, second, fraction)
TINYINT	XO_TYPE_TINYINT	byte [ ]
VARBINARY	XO_TYPE_VARBINARY	byte [ ]
VARCHAR	XO_TYPE_VARCHAR	StringBuilder – string of characters
WCHAR	XO_TYPE_WCHAR	StringBuilder – string of Unicode characters
WLONGVARCHAR	XO_TYPE_WLONGVARCHAR	StringBuilder – string of Unicode characters
WVARCHAR	XO_TYPE_WVARCHAR	StringBuilder – string of Unicode characters

Table 34 details how an object is interpreted when returned from a method. The class of the object returned by the methods depends on the type of the column or the condition. For example, if the left condition value type is XO_TYPE_CHAR, then calling dam_getCondVal on that condition will return an object of type String.

Table 34: How the methods for .NET return a value as an object
XO type of the condition or the column	Class type of the returned object
XO_TYPE_BIGINT	long
XO_TYPE_BINARY	byte [ ]
XO_TYPE_BIT	bool
XO_TYPE_CHAR	string
XO_TYPE_DATE	DateTime
XO_TYPE_DOUBLE	double
XO_TYPE_FLOAT	double
XO_TYPE_INTEGER	Integer
XO_TYPE_LONGVARBINARY	byte [ ]
XO_TYPE_LONGVARCHAR	string
XO_TYPE_NUMERIC	string
XO_TYPE_REAL	float
XO_TYPE_SMALLINT	short
XO_TYPE_TIME	DateTime
XO_TYPE_TIMESTAMP	DateTime
XO_TYPE_TINYINT	byte [ ]
XO_TYPE_VARBINARY	byte [ ]
XO_TYPE_VARCHAR	string - string of characters
XO_TYPE_WCHAR	string
XO_TYPE_WLONGVARCHAR	string
XO_TYPE_WVARCHAR	string