skip to main content
OpenAccess SDK SQL Engine core methods for .NET : Methods for .NET reference : dam_addColAliasxxxValToRow
 

dam_addColAliasxxxValToRow

These methods are used to build up a row by adding values for result columns based on Alias names. The result column handle refers to column handles returned by dam_describeColResAlias.
These methods require all data to be passed in using the same format as the column definition in the schema database or in any format for which a conversion is supported. Please refer to the following data conversion table:
http://www.datadirect.com/download/docs/openaccess/alloa/dataconversiontable.htm
NULL data is added by specifying the XO_NULL_DATA value flag for the column value length. These methods copy data from the user supplied buffer to its internal buffers and therefore the IP can free the memory associated with the input buffer (colVal).
Data type specific methods exist for a .NET IP.
int dam_addColAliasBigIntValToRow(
int64 hstmt,
int64 hRow,
int64 hColAlias,
long colVal,
int lColValLen)
int dam_addColAliasBinaryValToRow(
int64 dam_hstmt,
int64 hRow,
int64 hColAlias,
byte[] colVal,
int ColValLen)
int dam_addColAliasBitValToRow(
int64 hstmt,
int64 hRow,
int64 hColAlias,
bool colVal,
int lColValLen)
int dam_addColAliasCharValToRow(
int64 hstmt,
int64 hRow,
int64 hColAlias,
String colVal,
int lColValLen)
int dam_addColAliasWCharValToRow(
int64 hstmt,
int64 hRow,
int64 hColAlias,
String colVal,
int lColValLen)
int dam_addColAliasDoubleValToRow(
int64 hstmt,
int64 hRow,
int64 hColAlias,
double colVal,
int lColValLen)
int dam_addColAliasFloatValToRow(
int64 hstmt,
int64 hRow,
int64 hColAlias,
float colVal,
int lColValLen)
int dam_addColAliasIntValToRow(
int64 hstmt,
int64 hRow,
int64 hColAlias,
int colVal,
int lColValLen)
int dam_addColAliasShortValToRow(
int64 hstmt,
int64 hRow,
int64 hColAlias,
short colVal,
int lColValLen)
int dam_addColAliasTimeStampValToRow(
int64 hstmt,
int64 hRow,
int64 hColAlias,
ref DateTime colVal,
int lColValLen)
int dam_addColAliasTinyIntValToRow(
int64 hstmt,
int64 hRow,
int64 hColAlias,
byte colVal,
int lColValLen)
 
Table 86: Parameters for dam_addColAliasxxxValToRow 
Parameter
Type
Description
IN
 
 
hstmt
int64
The statement handle
hRow
int64
The row handle
hColAlias
int64
The column handle returned from dam_describeColResAlias
colVal
Depends on the method used
The .NET type of the data should correspond to the iXoType value. See Table 34.
IColValLen
int
The length of the data:
XO_NULL_DATA – indicates a null value
For VARCHAR, CHAR, WVARCHAR, WCHAR, and NUMERIC, either number of characters or XO_NTS to add the entire string.
For all other data types, 0 or any value other than XO_NULL_DATA.
RETURN
 
 
 
int
DAM_SUCCESS – added the value to the row
DAM_FAILURE – error adding the value
The LONGVARBINARY type can be provided to the OpenAccess SDK SQL Engine in segments by calling this method multiple times. In each call, include the data and its length. Also, the data must be provided as binary data and not as character data.

See also 

• dam_describeColResAlias