From: | "j(dot)letzel(at)t-online(dot)de" <j(dot)letzel(at)t-online(dot)de> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Bug in SQLRowCount ? |
Date: | 2013-01-17 09:31:05 |
Message-ID: | 1TvloP-15Bhtg0@fwd04.aul.t-online.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello !
I maintain a backend in a commercial context. The backend provides
access to MS SQLServer (via ODBC) and Oracle (via OCI). Now I want to
make it ready for PostgreSQL via ODBC.
For performance reasons we use bulk inserts/updates.
This is done in this manner:
SQLAllocStmt
SQLPrepare // insert into kfztest.KP values (?,?,...,?)
SQBindParameter // for each column
...
SQLSetStmtAttr // SQL_ATTR_PARAMSET_SIZE to 523
SQLSetStmtAttr // SQL_ATTR_PARAM_STATUS_PTR to an array of
SQLSMALLINT
SQLSetStmtAttr // SQL_ATTR_PARAMS_PROCESSED_PTR to an SQLULEN
variable
SQLExecute // ends with SQL_SUCCESS
SQLRowCount // delivers 1 !!!!
SQLEndTrans // with COMMIT
When necessary I can provide a full ODBC trace.
All records were written into table.
Thanks in advance.
Regards
Johann Letzel
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2013-01-17 13:08:36 | Re: Bug in SQLRowCount ? |
Previous Message | Hiroshi Inoue | 2013-01-11 03:40:17 | Re: Source code cleanup |