Problem with SQL_LONGVARBINAY

From: "Han" <zhouhanok(at)vip(dot)sina(dot)com>
To: pgsql-odbc(at)postgresql(dot)org <pgsql-odbc(at)postgresql(dot)org>
Cc: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Subject: Problem with SQL_LONGVARBINAY
Date: 2003-03-17 09:06:51
Message-ID: 20030317090032.3D0B7476105@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,
There's a problem when insert a SQL_LONGVARBINARY(lo) column in the following way:
Use SQLBindParameter(...SQL_DATA_AT_EXEC)
and SQLParamData, SQLPutData.
The last time SQLParamData revoke a crash!
This is the sample code:
for (...)
{
sdw = SQL_DATA_AT_EXEC;
rc = SQLBindParameter(hstmt, w, SQL_PARAM_INPUT,
SQL_C_TCHAR, rgFields[ind].wSQLType,
rgFields[ind].precision, rgFields[ind].scale,
(LPTSTR)(((UDWORD)ind)+BIND_PARM_OFFSET), 0, &sdw);
}
rc = SQLExecDirect(hstmt, lpqt->sz, SQL_NTS);
if (SQL_NEED_DATA != rc)
return;
for(ind = 0; ind <= cTypes; ind++)
{
rc = SQLParamData(hstmt, &ptr);
if(rc != SQL_NEED_DATA)
break;

pch = qtMakeData(...);

if(*pch) {
rc = SQLPutData(hstmt, pch, SQL_NTS);
} else {
rc = SQLPutData(hstmt, (LPTSTR)IGNORED, SQL_NULL_DATA);
}
}

please check, thanks and regards!

        

        Han
        zhouhanok(at)vip(dot)sina(dot)com
          2003-03-17

Browse pgsql-odbc by date

  From Date Subject
Next Message Adrian Klaver 2003-03-17 13:46:59 psqlODBC&unixODBC
Previous Message Renê Salomão 2003-03-14 13:52:01 Recipe for ODBC source