[ wxwindows-Bugs-1731257 ] wxDbTable::Insert many BLOB (LONGBINARY)

[SourceForge.net]

Bugs item #1731257, was opened at 2007-06-05 11:09
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109863&aid=1731257&group_id=9863

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Database
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Baldassarre Cesarano (bcesarano)
Assigned to: Nobody/Anonymous (nobody)
Summary: wxDbTable::Insert many BLOB (LONGBINARY)

Initial Comment:
Defining a wxDbTable with 2 (or more) blob the insert fail without an error message!

Motivation:
In the metod "wxDbTable::Insert" (dbtable.cpp) the second calling to "SQLParamData" can return the code 99 (SQL_NEED_DATA)
that is not contemplated in the next "if" but is previewed in the main loop (while).


Possible solution:
You can replace the code:
            retcode = SQLParamData(hstmtInsert, &pParmID);
            if (retcode != SQL_SUCCESS &&
                retcode != SQL_SUCCESS_WITH_INFO)
            {
with
            retcode = SQLParamData(hstmtInsert, &pParmID);
            if (retcode != SQL_SUCCESS &&
                retcode != SQL_NEED_DATA &&
                retcode != SQL_SUCCESS_WITH_INFO)
            {




----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109863&aid=1731257&group_id=9863