Unable to write string data

[Li Sze]

Hi all,

I'm using SQLBindParameters to bind the columns to variables of type integer, string 
and binary. There was no error during binding and writing. However, the string data 
are all NULL when I checked the database entries. I figured it could be a mistake in 
the SQLBindParameter parameters. 

What exactly should I put for the StrLen_or_IndPtr argument (the last argument)? 
Should it be NULL, 0 or SQL_NTS? Please advise.

------------------------------------------------------------------------------------------------
char    chDataType[12];

   g_rc = SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_VARCHAR, 
    1, 0, (SQLPOINTER)chDataType, 12, &cbCharData);
------------------------------------------------------------------------------------------------


Thanks,
Li SZe