Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-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

pgsql-odbc by date

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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group