ODBC – Retrieving Data From Sybase

You should be able to add something like this right after the fetch:

For multiple rows:

That is correct, what you need to remember is that the return value of the fetch is going to be the return code for the command.  In this case “SQL_SUCCESS”.

These lines tell the driver to bind the value returned from column 1 to the variable sname and the value returned from column 2 to the variable fname.

odbc SQLBindCol $hstmt 1 SQL_C_CHAR sname 30 pcbValue1

odbc SQLBindCol $hstmt 2 SQL_C_CHAR fname 30 pcbValue2