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

Is there a limit on what can be returned?

From: "Corey W(dot) Gibbs" <cgibbs(at)westmarkproducts(dot)com>
To: "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: Is there a limit on what can be returned?
Date: 2002-05-20 21:53:29
Message-ID: 01C2000E.1B606700.cgibbs@westmarkproducts.com (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-odbc
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:
rs.Open "SELECT jobno,itemno,room,model,w,h,d,qty FROM itemlist WHERE 
jobno='" & lst_job_numbers & "' and room = '" & lst_rooms & "'", cn, 
adOpenKeyset, adLockOptimistic
and the proverbial "all hell" breaks loose.

I get the following error message:
VB6.exe Application Error
The instruction at "0x0523abb5" referenced memory at "0xbfffffffc".  The 
memory could not be "written".

So i click Cancel to go into the MS Visual C++ debugger and i get this 
message box:
Unhandled exception in VB6.EXE (PSQLODBC.DLL):0xC0000005: Access Violation


Once in the debugger, i see much stuff that i sort of recognize, but it's 
been years since i've written in assembly language :)
here's the line it's pointing to:
                                     0523ABB0   push        52577D0h
is the line it's complaining about=> 0523ABB5   mov         byte ptr 
[edi+esi],0

here's the table definition from PGAdmin-II (nice job on that software btw) 
(i didn't set this up, it's been imported from an access datafile that i 
didn't set up either :( )
-- Table: itemlist
CREATE TABLE "itemlist" (
  "uniqueid" int4 DEFAULT nextval('Itemlist_UniqueID_key'::text) NOT NULL,
  "jobno" varchar(50),
  "fulldwgpath" varchar(150),
  "area" varchar(50),
  "floor" varchar(50),
  "building" varchar(50),
  "room" varchar(150),
  "elevation" varchar(50),
  "phase" varchar(50),
  "cycle" varchar(50),
  "model" varchar(150),
  "w" varchar(150),
  "h" varchar(50),
  "d" varchar(50),
  "itemno" varchar(50),
  "notes" text,
  "finish" varchar(150),
  "mtostatus" varchar(50) DEFAULT 'No',
  "qty" int4 DEFAULT 1,
  "color" varchar(50),
  "handle" varchar(50),
  "locks" varchar(50),
  "lockgroup" varchar(50),
  "data1" varchar(50),
  "data2" varchar(50),
  "data3" varchar(50),
  CONSTRAINT "ItemList_UniqueID_idx" UNIQUE ("uniqueid"),
  CONSTRAINT "ItemList_pkey" PRIMARY KEY ("uniqueid")
) WITH OIDS;

I know i need to work on the table definition, but I'm not the creator of 
the application that made this table.

Any help would be greatly appreciated.  I am able to reproduce the problem, 
so if anyone needs any further information, let me know.

thanks in advance
Corey Gibbs


Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-05-20 23:31:00
Subject: Re: int8 defined as text in MS Access?
Previous:From: Gareth KirwanDate: 2002-05-20 16:40:46
Subject: Re: Interval to number

pgsql-interfaces by date

Next:From: Hiroshi InoueDate: 2002-05-20 23:40:51
Subject: Re: [ODBC] Is there a limit on what can be returned?
Previous:From: Ed SchallerDate: 2002-05-20 19:20:42
Subject: Re: krb5 & multiple users

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