Is there a limit on what can be returned?
От | Corey W. Gibbs |
---|---|
Тема | Is there a limit on what can be returned? |
Дата | |
Msg-id | 01C2000E.1B606700.cgibbs@westmarkproducts.com обсуждение исходный текст |
Список | pgsql-interfaces |
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
В списке pgsql-interfaces по дате отправления: