Re: SQLParamOptions(): Incorrect base for returned row.

From: Barry Cohen <bcohen(at)usdata(dot)com>
To: 'Hiroshi Inoue' <Inoue(at)tpf(dot)co(dot)jp>
Cc: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: SQLParamOptions(): Incorrect base for returned row.
Date: 2002-10-28 17:25:36
Message-ID: 7AE316508068D311BE7700A0C9B6BA550284B73B@EXCH_CLUSTER
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Yes. The index problem seems to only occur during an error case.

If all rows are successfully inserted, then 'pirow' equals 'crow', which is
correct.

The index problem occurs for error encountered during block inserts,
deletes, and updates.

Regards,
bjc

-----Original Message-----
From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
Sent: Sunday, October 27, 2002 9:57 PM
To: Barry Cohen
Cc: 'pgsql-odbc(at)postgresql(dot)org'
Subject: Re: [ODBC] SQLParamOptions(): Incorrect base for returned row.

Barry Cohen wrote:
>
> Server: PostgreSQL Server on Linux (as bundled with RedHat 7.3)
> Client: Windows Insight Distribution Systems driver 7.02.00.03
>
> Hello,
>
> When performing a block insert, SQLParamOptions() can be used
> to return the index of the last row processed. According to
> the MSDN documentation, the index should be one based.
>
> MSDN: "As a statement executes, the driver sets pirow to the
> number of the current row of parameter values; the first row
> is row number 1. The contents of pirow can be used as follows: ..."
>
> The PostgreSQL driver seems to be returning an index that is zero based.

Is this only for error cases ?

regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2002-10-29 10:43:16 Re: SQLParamOptions(): Incorrect base for returned row.
Previous Message Hiroshi Inoue 2002-10-28 03:56:53 Re: SQLParamOptions(): Incorrect base for returned row.