SQL Engine parse tree methods for .NET : SQL pass-through and advanced query methods reference : damex_addxxxResValToRow

damex_addxxxResValToRow

This method is used to build up a row by adding values for the result column. NULL data is added by specifying the XO_NULL_DATA value flag for the value length.

This method copies data from the user supplied buffer to its internal buffers and therefore the IP can free the memory associated with the input buffer (colVal).

The following data type specific methods exist for NET:

int damex_addBigIntResValToRow(

int64 hstmt,

int64 hRow,

int iResColNum,

long colVal,

int lColValLen)

int damex_addBinaryResValToRow(

int64 hstmt,

int64 hRow,

int iResColNum,

byte[] colVal,

int lColValLen)

int damex_addBitResValToRow(

int64 hstmt,

int64 hRow,

int hCol,

bool colVal,

int lColValLen)

int damex_addCharResValToRow(

int64 hstmt,

int64 hRow,

int iResColNum,

String colVal,

int lColValLen)

int damex_addDoubleResValToRow(

int64 hstmt,

int64 hRow,

int iResColNum,

double colVal,

int lColValLen)

int damex_addFloatResValToRow(

int64 hstmt,

int64 hRow,

int iResColNum,

float colVal,

int lColValLen)

int damex_addIntResValToRow(

int64 hstmt,

int64 hRow,

int iResColNum,

int colVal,

int lColValLen)

int damex_addShortResValToRow(

int64 hstmt,

int64 hRow,

int iResColNum,

short colVal,

int lColValLen)

int damex_addTimeStampResValToRow(

int64 hstmt,

int64 hRow,

int iResColNum,

xo_tm colVal,

int lColValLen)

int damex_addTinyIntResValToRow(

int64 hstmt,

int64 hRow,

int hCol,

byte colVal,

int lColValLen)

int damex_addWCharResValToRow(

int64 hstmt,

int64 hRow,

int iResColNum,

String colVal,

int lColValLen)

Table 206: Parameters for damex_addxxxResValToRow
Parameter	Type	Description
IN
hstmt	int64	The statement handle
hRow	int64	The row handle
iResColNum	int	The result column number
iXoType	int	The data type. This can be any data type from which a conversion to the column's data types is supported. Please refer to the following data conversion table: http://www.datadirect.com/download/docs/openaccess/alloa/dataconversiontable.htm
colVal	depends on the method used	The .NET type of the data should correspond to the iXoType value. See Table 34.
pColValLen	int	The length of the data: XO_NULL_DATA – indicates a null value For VARCHAR, CHAR and NUMERIC, 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