Bug in SQLRowCount ?

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

Responses

Browse pgsql-odbc by date

  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