Re: [ODBC] Is there a limit on what can be returned?

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: "cgibbs(at)westmarkproducts(dot)com" <cgibbs(at)westmarkproducts(dot)com>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>, "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [ODBC] Is there a limit on what can be returned?
Date: 2002-05-20 23:40:51
Message-ID: 3CE98983.DDCCCBBD@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-odbc

"Corey W. Gibbs" wrote:
>
> Good Morning Everyone,
>
> I'm working on "Spiffy VB App that uses Postgres as it's backend number
> three" and I am encountering a weird problem.
> PG Driver is version 7.02.00.01 and MDAC is version 2.7 . Should I use
> MDAC2.5?
>
> When I execute the line below, everything is just fine:
> rs.Open "SELECT * FROM itemlist WHERE jobno='" & lst_job_numbers & "' and
> room = '" & lst_rooms & "'", cn, adOpenKeyset, adLockOptimistic
>
> But, I only need eight columns returned, so I try this:

It may be due to my fault.
Please try the snapshot dll at http://w2422.nsk.ne.jp/~inoue/.

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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Arindam Haldar 2002-05-21 12:16:48 want basic help with C
Previous Message Corey W. Gibbs 2002-05-20 21:53:29 Is there a limit on what can be returned?

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2002-05-21 07:17:14 Re:
Previous Message Hiroshi Inoue 2002-05-20 23:31:00 Re: int8 defined as text in MS Access?