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
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 |