SQLBindParameter question..

I found SQLBindParameter is very difficult to use, even I read all help files, I still could not be able to use it. Could anyone give me some helpful tips about using this API please.
stephenkongAsked:
Who is Participating?
 
jindaConnect With a Mentor Commented:
Example:

void MyFunction( void* Value, long lSize )
{
SDWORD cb_value;
CString strStmt;
long lID = 101;

strStmt.Format( "insert into myTable"
            " ( ID, BINARYVALUE )"
            " values"
            " (%ld, ?)",
            lID );


cb_value = lSize;

nRc = SQLBindParameter( hStmt, 1, SQL_PARAM_INPUT,
            SQC_C_BINARY,
            SQL_BINARY,
            lSize, 0, Value, 0, &cb_value);

nRc = SQLExecDirect( hStmt, (unsigned char*)(LPCSTR)strStmt, SQL_NTS);

..
}


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.