skip to main content
SQL Engine parse tree methods for .NET : SQL pass-through and advanced query methods reference : damex_describeInsertQuery
 

damex_describeInsertQuery

This method returns details about the INSERT query.
int damex_describeInsertQuery(
int64 hquery,
out int64 phTable,
out int64 phColList,
out int64 phInsertRowList,
out int64 phInsertQuery)
 
Table 214: Parameters for damex_describeInsertQuery 
Parameter
Type
Description
IN
 
 
hquery
int64
The query handle.
OUT
 
 
phTable
int64
The handle to the insert table. Use damex_describeTable to get the table details.
phColList
int64
The handle to the column list of the insert query. Use damex_getFirstColInList, damex_getNextColInList to get the insert columns and damex_describeCol to get each of the column details.
phInsertRowList
int64
The handle to the rows containing the values specified in the INSERT query.
Use damex_getFirstInsertRow, damex_getNextInsertRow to navigate the multiple insert value lists specified. If only one set of values are specified, the first call to damex_getNextInsertRow will return NULL.
Use damex_getFirstInsertValExp and damex_getNextInsertValExp to navigate each of the rows.
phInsertQuery
int64
The handle to the query whose result table rows are to be used as values to be inserted. The value of phInsertRowList will be NULL when this value is returned. Use damex_describeSelectQuery to get query details.
RETURN
 
 
 
int
DAM_SUCCESS – on success
DAM_FAILURE – on failure

See also 

damex_describeCol
damex_describeSelectQuery
damex_getFirstColInList
damex_getFirstInsertRow
damex_getFirstInsertValExp
damex_getNextColInList
damex_getNextInsertRow
damex_getNextInsertValExp