Received: from smtp.pandora.be (hercules.telenet-ops.be [195.130.132.33]) by hub.org (8.9.3/8.9.3) with SMTP id JAA64799 for ; Sun, 27 Feb 2000 09:15:37 -0500 (EST) (envelope-from Willy.DelaCourt@pandora.be) Received: (qmail 14113 invoked from network); 27 Feb 2000 14:15:32 -0000 Received: from unknown (HELO stargate.speedy.home) ([195.130.137.182]) (envelope-sender ) by hercules.telenet-ops.be (qmail-ldap-1.03) with SMTP for ; 27 Feb 2000 14:15:32 -0000 Received: from daffy (DAFFY.speedy.home [192.168.1.30]) by stargate.speedy.home (8.9.3/8.9.3) with SMTP id PAA00861 for ; Sun, 27 Feb 2000 15:15:37 +0100 Received: by localhost with Microsoft MAPI; Sun, 27 Feb 2000 15:16:38 +0100 Message-ID: <01BF8135.A4DA8F60.Willy.DelaCourt@pandora.be> From: Willy De la Court To: "'pgsql-interfaces@postgresql.org'" Subject: pgsql ODBC driver and Visual Foxpro Date: Sun, 27 Feb 2000 15:16:37 +0100 X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 Encoding: 40 TEXT, 279 UUENCODE, 136 UUENCODE X-MS-Attachment: SQL.LOG 0 00-00-1980 00:00 X-MS-Attachment: psqlodbc.log 0 00-00-1980 00:00 Hi, I'v got the following problem with Visual Foxpro (VFP) and using the pgsql ODBC driver. With Visual Foxpro it is possible to create parametrized views it looks something like this. create sql view xxx remote connection bms as select * from peo where peo_name = 'A' and peo_code = ?ncode where '?ncode' is the parameter. Normaly the ?ncode is replaced before the select statement is send to the backend. visual foxpro will try first to send the query unmodified to the backend. and always it gets an error from the backend. Here is a piece of the log. statement_type=0, statement='select * from peo where peo_name = 'A' and peo_code = ?' stmt_with_params='select * from peo where peo_name = 'A' and peo_code = ' Then VFP even after it got an error it will try to get the number of rows returned. STATEMENT ERROR: func=SQLNumResultCols, desc='', errnum=3, errmsg='No query has been executed with that handle' This error message is also normal. Then VFP tries to execute an SQLExecDirect with "select * from peo WHERE 0=1" and this fails also which is not normal. STATEMENT ERROR: func=SQLExecute, desc='', errnum=2, errmsg='The handle does not point to a statement that is ready to be executed' AND LOOK AT THESE 2 LINES IN THE LOGFILE. statement_type=0, statement='select * from peo WHERE 1=0' stmt_with_params='select * from peo where peo_name = 'A' and peo_code = ' What happend here??????? Can somebody please help me with this I need the odbc driver to work with visual foxpro. PS normal SQL statements without the functionality of parameters work great. Included are both the sql.log and the psqlodbc.log begin 600 SQL.LOG M#0I61E V(" @(" @(" @(" @9F9F8C-B93# P83-F-#4T#0H-"E9&4#8@ M(" @(" @(" @("!F9F9B,V)E-SIF9F8X9#9A8@E%6$E4("!344Q!;&QO8T-O M;FYE8W0@('=I=&@@# R8S# R8S# R8S# R8S#%F-&)E M,#8X(%L@(" @(" M,UT@(BHJ*BHJ*EP@,"(-"@D)4U=/4D0@(" @(" @(" @ M(" @(" @(" @(" @("TS( T*"0E70TA!4B J(" @(" @(" @(" @(#!X,68T M8F4P-C@@#0H)"5-73U)$(" @(" @(" @(" @(" @(" @(" @(" @." -"@D) M4U=/4D0@*B @(" @(" @(" @(" P># P,# P,# P#0H)"5573U)$(" @(" @ M(" @(" @(" @(" @(" @(" @,2 \4U%,7T12259%4E]#3TU03$5413X-"@T* M5D90-B @(" @(" @(" @(&9F9F(S8F4W.F9F9CAD-F%B"45.5$52(%-13$%L M;&]C4W1M=" -"@D)2$1"0R @(" @(" @(" @(" @(" P># R8S# R8S# R M8S# P83-F,60V("@Q,"D-"@T* M5D90-B @(" @(" @(" @(&9F9F(S8F4W.F9F9CAD-F%B"45.5$52(%-13$=E M=$EN9F]7( T*"0E(1$)#(" @(" @(" @(" @(" @(#!X,#)C-S!A,S0-"@D) M55=/4D0@(" @(" @(" @(" @(" @(" @(" @(#0W(#Q344Q?55-%4E].04U% M/@T*"0E05%(@(" @(" @(" @(" @(" @(#!X,#)C-S X.#0@#0H)"5-73U)$ M(" @(" @(" @(" @(" @(" @(" @(#$R." -"@D)4U=/4D0@*B @(" @(" @ M(" @(" P># P83-F,60V#0H-"E9&4#8@(" @(" @(" @("!F9F9B,V)E-SIF M9F8X9#9A8@E%6$E4("!344Q'971);F9O5R @=VET:"!R971U# R8S

# R8S# R8S# P83-F,60T#0H) M"5-73U)$(" @(" @(" @(" @(" @(" @(" @(" @,B -"@D)4U=/4D0@*B @ M(" @(" @(" @(" P># P83-F,60V#0H-"E9&4#8@(" @(" @(" @("!F9F9B M,V)E-SIF9F8X9#9A8@E%6$E4("!344Q'971);F9O5R @=VET:"!R971U# R8S# P83-F,60T("@R*0T*"0E35T]21" @(" @(" @(" @(" @(" @(" @(" @ M(#(@#0H)"5-73U)$("H@(" @(" @(" @(" @,'@P,&$S9C%D-B H,BD-"@T* M5D90-B @(" @(" @(" @(&9F9F(S8F4W.F9F9CAD-F%B"45.5$52(%-13$=E M=$EN9F]7( T*"0E(1$)#(" @(" @(" @(" @(" @(#!X,#)C-S!A,S0-"@D) M55=/4D0@(" @(" @(" @(" @(" @(" @(" @(#(Y(#Q344Q?241%3E1)1DE% M4E]154]415]#2$%2/@T*"0E05%(@(" @(" @(" @(" @(" @(#!X,#)C-S!F M,#0@#0H)"5-73U)$(" @(" @(" @(" @(" @(" @(" @(#$R." -"@D)4U=/ M4D0@*B @(" @(" @(" @(" P># P83-F,60V#0H-"E9&4#8@(" @(" @(" @ M("!F9F9B,V)E-SIF9F8X9#9A8@E%6$E4("!344Q'971);F9O5R @=VET:"!R M971U# R8S# R8S# P83-F,60V("@R*0T*#0I61E V(" @(" @(" @(" @9F9F8C-B M93# P M83-F,60V#0H-"E9&4#8@(" @(" @(" @("!F9F9B,V)E-SIF9F8X9#9A8@E% M6$E4("!344Q'971);F9O5R @=VET:"!R971U# R8S# R8S# R8S# P83-F,60V("@R*0T* M#0I61E V(" @(" @(" @(" @9F9F8C-B93# R8S# R8S# R8S# P83-F,S0R#0H-"@D)1$E!1R!;4S$P,3!=($YO('%U97)Y(&AA&5C1&ER96-T M( T*"0E(4U1-5" @(" @(" @(" @(" @(#!X,#)C-S$V,#0-"@D)54-(05(@ M*B @(" @(" @(" @(" P># Q-&)B-V)C(%L@(" @(" M,UT@(G-E;&5C=" J M(&9R;VT@<&5O("!72$5212 Q/3!<(# B#0H)"5-$5T]21" @(" @(" @(" @ M(" @(" @(" @+3,-"@T*5D90-B @(" @(" @(" @(&9F9F(S8F4W.F9F9CAD M-F%B"458250@(%-13$5X96-$:7)E8W0@('=I=&@@# R8S2!T;R!B92!E>&5C=71E9#L-"D524D]2.B @<&%R# R9#9F9C%C#0H)"4A$0D,@(" @(" @(" @(" @(" @ M,'@P,F,W,&$S- T*"0E(4U1-5" @(" @(" @(" @(" @(#!X,#)C-S$V,#0- M"@D)5T-(05(@*B @(" @(" @(" @(" P># P83-E9#!C("A.64DI( T*( D) M4T173U)$("H@(" @(" @(" @(" P># P83-F,6,T#0H)"5=#2$%2("H@(" @ M(" @(" @(" @,'@P,&$S93DP8R -"@D)4U=/4D0@(" @(" @(" @(" @(" @ M(" @(" @-3$R( T*"0E35T]21" J(" @(" @(" @(" @(#!X,#!A,V8Q8V$- M"@T*5D90-B @(" @(" @(" @(&9F9F(S8F4W.F9F9CAD-F%B"458250@(%-1 M3$5R# R9#9F9C%C#0H)"4A$0D,@(" @(" @ M(" @(" @(" @,'@P,F,W,&$S- T*"0E(4U1-5" @(" @(" @(" @(" @(#!X M,#)C-S$V,#0-"@D)5T-(05(@*B @(" @(" @(" @(" P># P83-E9#!C("A. M64DI( T*( D)4T173U)$("H@(" @(" @(" @(" P># P83-F,6,T("@R*0T* M"0E70TA!4B J(" @(" @(" @(" @(#!X,#!A,V4Y,&,@6R @(" @,3$R72 B M5&AE(&AA;F1L92!D;V5S(&YO="!P;VEN="!T;R!A('-T871E;65N="!T:&%T M(&ES(')E861Y('0B#0H)"5-73U)$(" @(" @(" @(" @(" @(" @(" @(#4Q M,B -"@D)4U=/4D0@*B @(" @(" @(" @(" P># P83-F,6-A("@Q,3(I#0H- M"E9&4#8@(" @(" @(" @("!F9F9B,V)E-SIF9F8X9#9A8@E%3E1%4B!344Q% M# R8S# P83-F,6-A#0H-"E9&4#8@(" @(" @(" @("!F9F9B,V)E M-SIF9F8X9#9A8@E%6$E4("!344Q%# R9#9F9C%C#0H)"4A$0D,@(" @(" @(" @(" @(" @,'@P,F,W,&$S M- T*"0E(4U1-5" @(" @(" @(" @(" @(#!X,#)C-S$V,#0-"@D)5T-(05(@ M*B @(" @(" @(" @(" P># P83-E9#!C("A.64DI( T*( D)4T173U)$("H@ M(" @(" @(" @(" P># P83-F,6,T#0H)"5=#2$%2("H@(" @(" @(" @(" @ M,'@P,&$S93DP8R -"@D)4U=/4D0@(" @(" @(" @(" @(" @(" @(" @-3$R M( T*"0E35T]21" J(" @(" @(" @(" @(#!X,#!A,V8Q8V$-"@T*5D90-B @ M(" @(" @(" @(&9F9F(S8F4W.F9F9CAD-F%B"45.5$52(%-13$-A;F-E;" - M"@D)2%-4350@(" @(" @(" @(" @(" P># R8S# R8S# R8S# R8S7-T86)L93TG,"<-"B @(" @(" @("!C;VYN7W-E='1I;F=S/2F5S/3 L(&UA>%]V M87)C:&%R7W-I>F4],C4T+"!M87A?;&]N9W9A'1R85]S>7-T86)L95]P3TG3TG7!N86UE/2=L;R2<- M"B @(" @(" @(" @(" @(" @+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM#0H@(" @(" @(" @ M(" @(" @(&AD8F,]-3 W.3(U-S(L('-T;70]-3 X,#%)O=W,],"P@F4],2P@:V5YF4],"P@8W5R%)O=W,],"P@F4],2P@:V5YF4],"P@8W5R7!E/3 L M('-T871E;65N=#TG&5C/2TQ+"!C=7)R96YT7V5X M96-?<&%R86T]+3$L('!U=%]D871A/3 -"B @(" @(" @(" @(" @(" @8W5R M7-E=%]S M:7IE/3 L(&-U7!E/3 L('-C3TQ#0H@ M(" @(" @(" @(" @(" @(&-U&5C=71E+"!D97-C/27!E/2TY.3D-"B @(" @(" @(" @("TM+2TM+2TM+2TM M+2TM+2T@4V]C:V5T($EN9F\@+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM M+2TM+0T*(" @(" @(" @(" @