Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

Usage

  • Last Updated: May 12, 2026
  • 1 minute read
    • OpenAccess SDK
    • Version 8.1
    • Documentation

In a query of the form:

SELECT * FROM emp WHERE dept_id = 1 OR dept_id=2;

calling dam_getRestrictionList on column dept_id returns a restriction list with two conditions, C1 and C2, and column dept_id.

The first condition, C1, has the operator set to '=' and value set to 1.

The second condition, C2, has the operator set to '=' and value set to 2.

The IP should build rows where the dept_id is 1 and rows where the dept_id is 2.

/* Get restriction on column dept_id assuming hDeptId is the */ 
/* column handle */
hCondList = dam_getRestrictionList( hstmt, hDeptId);
hCond1 = dam_getFirstCond( hstmt, hCondList);
/* Call dam_describeCondEx() to get the operator type, operand and the */
/* data type */
hCond2 = dam_getNextCond(hstmt, hCondList );

See also

TitleResults for “How to create a CRG?”Also Available inAlert