Issue Details (XML | Word | Printable)

Key: ODBC-134
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Alexander Potapchenko
Reporter: Keith Patrick
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
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. Text File FBBlob2.cpp (4 kB)
2. Text File FBlob.cpp (5 kB)
3. Zip Archive 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



 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no subversion log entries for this issue yet.