[#ODBC-134] When inserting null data into multipl blob columns into a table the return value of SQLParamData return SQL_NEED_DATA when is should have return SQL_SUCCESS

ODBC Driver

When inserting null data into multipl blob columns into a table the return value of SQLParamData return SQL_NEED_DATA when is should have return SQL_SUCCESS

Created: 04/Jan/12 06:07 PM Updated: 01/Jan/15 03:31 PM

Component/s:

None

Affects Version/s:

2.0

Fix Version/s:

2.0.2

File Attachments:	1. FBBlob2.cpp (4 kB) 2. FBlob.cpp (5 kB) 3. OdbcFb.zip (1.16 MB)
Environment:	Window7

Description

« Hide

When inserting null data into multipl blob columns into a table the return value of SQLParamData returns SQL_NEED_DATA when is should have return SQL_SUCCESS.
A prior call to SQLPutData was made to assign a NULL value to the blob.
This does not occur if the table contains only one blob column. If there are more than two blob columns in the table then the the ParamData is also not set correctly.
For example:

    rc = ::SQLExecute ( hstmt );
    rc = ::SQLParamData ( hstmt, &ParamData );
    rc = ::SQLPutData ( hstmt, NULL, SQL_NULL_DATA );
    rc = ::SQLParamData ( hstmt, &ParamData );
    rc = ::SQLPutData ( hstmt, NULL, SQL_NULL_DATA );
    rc = ::SQLParamData ( hstmt, &ParamData ); // rc should be SQL_SUCCESS