SQLSetCursorName(hstmt, "CUPD1", SQL_NTS);

 

/* Set the cursor type */

SQLSetStmtAttr( hstmt,

    SQL_ATTR_CURSOR_TYPE,

    (SQLPOINTER) SQL_CURSOR_KEYSET,

    0);

/* Execute select query */

SQLExecDirect(hstmtS, "SELECT x, y FROM keyset_cursor", SQL_NTS);

 

/* Fetch scrollable cursor */

SQLFetchScroll(hstmtS, SQL_FETCH_NEXT, 0)) != SQL_ERROR)

 

/* Move cursor to record 4 */

SQLSetPos(hstmtS, 4, SQL_POSITION, SQL_LOCK_NO_CHANGE);

 

/* Bind a string parameter */

rc = SQLBindParameter(hstmtU, 1, SQL_PARAM_INPUT,

    SQL_C_CHAR, SQL_CHAR,

    TXT_LEN, 0, x[irow-1], 0, NULL);

 

/* Update the record */

SQLExecDirect(hstmtU,

    "UPDATE keyset_cursor SET x=? WHERE CURRENT OF CUPD", SQL_NTS);