dam_addxxxValToRow
- 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 columns, one at a time. 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
Character data can be added by supplying the length or by marking the data as null terminated. 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; therefore, the IP can free the memory associated with the input buffer (colVal).
A .NET IP uses specific data type methods.
int dam_addBigIntValToRow(
int64 hstmt,
int64 hRow,
int64 hCol,
long colVal,
int lColValLen)
int dam_addBinaryValToRow(
int64 dam_hstmt,
int64 hRow,
int64 hCol,
byte[] colVal,
int lColValLen)
int dam_addBitValToRow(
int64 dam_hstmt,
int64 hRow,
int64 hCol,
byte[] colVal,
int lColValLen)
int dam_addCharValToRow(
int64 hstmt,
int64 hRow,
int64 hCol,
String colVal,
int lColValLen)
int dam_addDoubleValToRow(
int64 hstmt,
int64 hRow,
int64 hCol,
double colVal,
int lColValLen)
int dam_addFloatValToRow(
int64 hstmt,
int64 hRow,
int64 hCol,
float colVal,
int lColValLen)
int dam_addIntValToRow(
int64 hstmt,
int64 hRow,
int64 hCol,
int colVal,
int lColValLen)
int dam_addShortValToRow(
int64 hstmt,
int64 hRow,
int64 hCol,
short colVal,
int lColValLen)
int dam_addTimeStampValToRow(
int64 hstmt,
int64 hRow,
int64 hCol,
ref DateTime colVal,
int lColValLen)
int dam_addTinyIntValToRow(
int64 hstmt,
int64 hRow,
int64 hCol,
int colVal,
int lColValLen)
int dam_addWCharValToRow(
int64 hstmt,
int64 hRow,
int64 hCol,
String colVal,
int lColValLen)
Parameters for dam_addxxxValToRow
| Parameter | Type | Description |
| IN | ||
| hstmt | int64 | The statement handle |
| hRow | int64 | The row handle |
| hCol | int64 | The column handle |
| colVal | depends on the method used | The .NET type of the data should correspond to the iXoType value. See Table 34. The data can be supplied in a format that corresponds to the column's definition in the schema or in any other format and the OpenAccess SDK SQL Engine will perform the required conversion. |
| IColValLen | int | The length of the data XO_NULL_DATA – indicates a null value For VARCHAR, CHAR, WVARCHAR, WCHAR, and NUMERIC, either the 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, LONGVARCHAR, and WLONGVARCHAR type of data (character data or binary data) can be provided to the OpenAccess SDK SQL Engine in segments by calling dam_addxxxValToRow multiple times. In each call, include the data and its length. However, for LONGVARBINARY, the data must be provided as binary data.