| 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: | Whole Thread | Raw Message | 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 |