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

dam_getOrderByCol

This method returns the column name and position in the schema for the specified ORDER BY column.
int dam_getOrderByCol(
int64 hstmt,
int iOrderByColNum,
out int piColNum,
StringBuilder pColName,
out int piSortOrder)
 
Table 170: Parameters for dam_getOrderByCol 
Parameter
Type
Description
IN
 
 
hstmt
int64
The statement handle
iOrderByColNum
int
The Order By column number, for which to return information. Valid numbers are 0 – (Value returned from dam_getInfo (DAM_INFO_ORDER_BY_OPTIMIZABLE) -1)
OUT
 
 
piColNum
int
The column number as defined in the schema database
pColName
StringBuilder
The column name as defined in the schema database
piSortOrder
int
The sort order for the column:
SQL_ORDER_ASC – Ascending
SQL_ORDER_DESC – Descending
RETURN
 
 
 
int
Status of the call:
DAM_SUCCESS – on success
DAM_FAILURE – wrong value for iOrderByColNum

See also 

dam_getInfo