ODBC Using SQLSpecialColumns

...
rc = SQLSpecialColumns(hstmt, SQL_BEST_ROWID, ...);
...
rc = SQLExecDirect(hstmt, "SELECT first_name, last_name, " +
                   "ssn, address, city, state, zip, ROWID " +
                   "FROM employees", SQL_NTS);
 
/* Fetch data and probably "hide" ROWID from the user */
...
rc = SQLExecDirect(hstmt, "UPDATE employees SET address = ? " +
                   "WHERE ROWID = ?", SQL_NTS);
/* Fastest access to the data! */