dam_addColAliasxxxValToRow
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 9.0
- Documentation
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:
https://documentation.progress.com/output/DataDirect/collateral/dataconversiontable.html
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)
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 rowDAM_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.