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

dam_addxxxValToRow

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:
http://www.datadirect.com/download/docs/openaccess/alloa/dataconversiontable.htm
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)
 
Table 94: 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.

See also 

• dam_addxxxValToRow