pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC SQLNumResultCols broken?
3+ messages / 3 participants
[nested] [flat]
* ODBC SQLNumResultCols broken?
@ 2000-10-21 02:22 Bill <bouma@cplane.com>
2000-10-21 07:52 ` Re: ODBC SQLNumResultCols broken? Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
0 siblings, 1 reply; 3+ messages in thread
From: Bill @ 2000-10-21 02:22 UTC (permalink / raw)
To: pgsql-interfaces
The ODBC book I have claims that if, after execution, a statement
has no result data, then SQLNumResultCols(statement, &ncols) returns
ncols == 0. TRUE? FALSE?
If TRUE, then postgresql ODBC driver (latest stuff) is broken because
it always returns the number of '?' there are in the SQL query
statement no matter if any rows were returned by the execute.
What I am really trying to do is test existence of an index "id" in a table.
I call SQLExecute() on a prepared statement that looks like this:
"select id from tablename where id = ?"
Parameter is bound, everything returns success. Now I can tell if
the id is in the table if any rows were returned from this query. Is
there some other or better way to do this?
Of course, postgresql ODBC and JDBC drivers are still broken in the
ways I have reported before, but no one seems to care. 8^(
Bill <bouma@cplane.com>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ODBC SQLNumResultCols broken?
2000-10-21 02:22 ODBC SQLNumResultCols broken? Bill <bouma@cplane.com>
@ 2000-10-21 07:52 ` Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
0 siblings, 0 replies; 3+ messages in thread
From: Kovacs Zoltan Sandor @ 2000-10-21 07:52 UTC (permalink / raw)
To: Bill <bouma@cplane.com>; +Cc: pgsql-interfaces
> Of course, postgresql ODBC and JDBC drivers are still broken in the
> ways I have reported before, but no one seems to care. 8^(
Yes, it is my great problem with the developers of the ODBC driver. My
patch is also not tested and added to the CVS for 6 months. 8^(
Zoltan
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: ODBC SQLNumResultCols broken?
@ 2000-10-23 08:13 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Dave Page @ 2000-10-23 08:13 UTC (permalink / raw)
To: pgsql-interfaces
> -----Original Message-----
> From: Kovacs Zoltan Sandor [mailto:tip@pc10.radnoti-szeged.sulinet.hu]
> Sent: 21 October 2000 07:52
> To: Bill
> Cc: pgsql-interfaces@postgresql.org
> Subject: Re: [INTERFACES] ODBC SQLNumResultCols broken?
>
>
> > Of course, postgresql ODBC and JDBC drivers are still broken in the
> > ways I have reported before, but no one seems to care. 8^(
> Yes, it is my great problem with the developers of the ODBC driver. My
> patch is also not tested and added to the CVS for 6 months. 8^(
>
> Zoltan
What developers? Up 'till a couple of months ago we relied on Byron for the
ODBC code (sincere apologies if anyone else was involved that I don't know
about). Now that Byron is unable (I assume not unwilling) to contribute as
he did, I think we need someone to take over responsibility or at least get
heavily involved as soon as possible.
I would volunteer myself, but my C is isn't really up to it and pgAdmin
takes a fair bit of time... Anyone else?
Regards,
Dave.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-10-23 08:13 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-21 02:22 ODBC SQLNumResultCols broken? Bill <bouma@cplane.com>
2000-10-21 07:52 ` Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
2000-10-23 08:13 RE: ODBC SQLNumResultCols broken? Dave Page <dpage@vale-housing.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox