From: | "Anoop Kumar" <anoopk(at)pervasive-postgres(dot)com> |
---|---|
To: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>, "Scot Loach" <sloach(at)sandvine(dot)com>, <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: psqlODBC 08.00.0102 available for download |
Date: | 2005-08-12 06:10:57 |
Message-ID: | B4AF8C04F762D246A1E38EC5DFAEFC0B0379C0@blrmail2.aus.pervasive.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Scot,
I am attaching a patch to solve the SQLRowCount() issue you have faced.
This should enable you to get the number of rows affected by an
INSERT/DELETE or UPDATE operation.
The old odbc driver returned the number of rows after a select
statement. Now the libpq enabled version returns a zero.
Regards
Anoop
> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-
> owner(at)postgresql(dot)org] On Behalf Of Dave Page
> Sent: Thursday, August 11, 2005 1:59 PM
> To: Scot Loach; pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] psqlODBC 08.00.0102 available for download
>
>
>
> > -----Original Message-----
> > From: Scot Loach [mailto:sloach(at)sandvine(dot)com]
> > Sent: 11 August 2005 03:56
> > To: Dave Page; pgsql-odbc(at)postgresql(dot)org
> > Subject: RE: [ODBC] psqlODBC 08.00.0102 available for download
> >
> > I finally got around to giving the new driver a try.
> >
> > There's one major problem I'm running into. Specifically,
> > the SQLRowCount() function doesn't work with the libpq
implementation.
> >
> > Can anyone comment on this?
>
> I'll investigate....
>
> /D
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
Attachment | Content-Type | Size |
---|---|---|
sqlrowcount_libpq.patch | application/octet-stream | 1.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2005-08-12 10:03:36 | Re: psqlODBC 08.00.0102 available for download |
Previous Message | Bobby Brewster | 2005-08-12 03:19:28 | Re: HELP: Unrecognized key passed to SQLGetInfo30(#209) |