Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA68515 for ; Fri, 30 Apr 1999 12:48:41 -0400 (EDT) (envelope-from jt-kirkpatrick@mpsllc.com) Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may be forged)) by s20.highertech.net (8.8.6/8.8.6) with SMTP id MAA11735 for ; Fri, 30 Apr 1999 12:47:50 -0400 Received: by localhost with Microsoft MAPI; Fri, 30 Apr 1999 12:50:40 -0400 Message-ID: <01BE9308.0D3A5260.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'pgsql-interfaces@hub.org'" Subject: not translating a query properly. . . Date: Fri, 30 Apr 1999 12:50:38 -0400 Organization: MPS, LLC X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="---- =_NextPart_000_01BE9308.0D437A20" ------ =_NextPart_000_01BE9308.0D437A20 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit here is my psqlodbc log -- it's short. i have two problems (or may just one). it still shows using version 6.3, but i completely removed 6.3 (in add/remove programs) and reinstalled 6.4. the other problem i am having is shown in it too -- i am in an access97 query sql view typing "select subnum from subs union all select vnum from vend;" (which works great from the psql prompt), but i am getting some kind of syntax error message. if you take the time to look into the file you'll also see another ongoing problem i am having with booleans in my queries (where i am trying to show all records that are 't' or =1 or any other way i try -- i just bombs). is there any reason why this query wouldn't run properly? i thought upgrading to the new version might help. . . jt ------ =_NextPart_000_01BE9308.0D437A20 Content-Type: application/octet-stream; name="psqlodbc.log" Content-Transfer-Encoding: base64 Y29ubj00Nzk3MjQ3MiwgU1FMRHJpdmVyQ29ubmVjdCggaW4pPSdEUklWRVI9e1Bvc3RncmVTUUx9 O1VJRD1raXJrcGFqdDtQV0Q9O0RBVEFCQVNFPXNlcnZpY2V3b3JrcztTRVJWRVI9Z3JlZW5tYW47 UE9SVD01NDMyO1JFQURPTkxZPTA7UFJPVE9DT0w9O0ZBS0VPSURJTkRFWD0wO1NIT1dPSURDT0xV TU49MDtST1dWRVJTSU9OSU5HPTA7U0hPV1NZU1RFTVRBQkxFUz0wO0NPTk5TRVRUSU5HUz07Jywg ZkRyaXZlckNvbXBsZXRpb249MA0KY29ubj00Nzk3MjQ3MiwgU1FMRHJpdmVyQ29ubmVjdChvdXQp PSdEUklWRVI9e1Bvc3RncmVTUUx9O0RBVEFCQVNFPXNlcnZpY2V3b3JrcztTRVJWRVI9Z3JlZW5t YW47UE9SVD01NDMyO1VJRD1raXJrcGFqdDtQV0Q9O1JFQURPTkxZPTA7UFJPVE9DT0w9O0ZBS0VP SURJTkRFWD0wO1NIT1dPSURDT0xVTU49MDtST1dWRVJTSU9OSU5HPTA7U0hPV1NZU1RFTVRBQkxF Uz0wO0NPTk5TRVRUSU5HUz0nDQpHbG9iYWwgT3B0aW9uczogVmVyc2lvbj0nMDYuMzAuMDI1MCcs IGZldGNoPTEwMCwgc29ja2V0PTQwOTYsIHVua25vd25fc2l6ZXM9MCwgbWF4X3ZhcmNoYXJfc2l6 ZT01NTAsIG1heF9sb25ndmFyY2hhcl9zaXplPTE1MDAwDQogICAgICAgICAgICAgICAgZGlzYWJs ZV9vcHRpbWl6ZXI9MCwgdW5pcXVlX2luZGV4PTEsIHVzZV9kZWNsYXJlZmV0Y2g9MQ0KICAgICAg ICAgICAgICAgIHRleHRfYXNfbG9uZ3ZhcmNoYXI9MSwgdW5rbm93bnNfYXNfbG9uZ3ZhcmNoYXI9 MCwgYm9vbHNfYXNfY2hhcj0xDQogICAgICAgICAgICAgICAgZXh0cmFfc3lzdGFibGVfcHJlZml4 ZXM9J2RkXzsnLCBjb25uX3NldHRpbmdzPScnDQpjb25uPTQ3OTcyNDcyLCBxdWVyeT0nICcNCmNv bm49NDc5NzI0NzIsIHF1ZXJ5PSdzZXQgRGF0ZVN0eWxlIHRvICdJU08nJw0KY29ubj00Nzk3MjQ3 MiwgcXVlcnk9J0JFR0lOJw0KY29ubj00Nzk3MjQ3MiwgcXVlcnk9J2RlY2xhcmUgU1FMX0NVUjAy REMzOTE0IGN1cnNvciBmb3Igc2VsZWN0IG9pZCBmcm9tIHBnX3R5cGUgd2hlcmUgdHlwbmFtZT0n bG8nJw0KY29ubj00Nzk3MjQ3MiwgcXVlcnk9J2ZldGNoIDEwMCBpbiBTUUxfQ1VSMDJEQzM5MTQn DQogICAgWyBmZXRjaGVkIDAgcm93cyBdDQpjb25uPTQ3OTcyNDcyLCBxdWVyeT0nY2xvc2UgU1FM X0NVUjAyREMzOTE0Jw0KY29ubj00Nzk3MjQ3MiwgcXVlcnk9J0VORCcNCmNvbm49NDc5NzI0NzIs IHF1ZXJ5PSdCRUdJTicNCmNvbm49NDc5NzI0NzIsIHF1ZXJ5PScoU0VMRUNUICJzdWJudW0iICBG Uk9NICJzdWJzIiApIFVOSU9OIEFMTCAoU0VMRUNUICJ2bnVtIiAgRlJPTSAidmVuZCIgKScNCkVS Uk9SIGZyb20gYmFja2VuZCBkdXJpbmcgc2VuZF9xdWVyeTogJ0VSUk9SOiAgcGFyc2VyOiBwYXJz ZSBlcnJvciBhdCBvciBuZWFyICIoIicNCmNvbm49NDc5NzI0NzIsIHF1ZXJ5PSdBQk9SVCcNClNU QVRFTUVOVCBFUlJPUjogZnVuYz1TQ19leGVjdXRlLCBkZXNjPScnLCBlcnJudW09MSwgZXJybXNn PSdFcnJvciB3aGlsZSBleGVjdXRpbmcgdGhlIHF1ZXJ5Jw0KICAgICAgICAgICAgICAgICAtLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0N CiAgICAgICAgICAgICAgICAgaGRiYz00Nzk3MjQ3Miwgc3RtdD00Nzk4Njk2NCwgcmVzdWx0PTAN CiAgICAgICAgICAgICAgICAgbWFudWFsX3Jlc3VsdD0wLCBwcmVwYXJlPTAsIGludGVybmFsPTAN CiAgICAgICAgICAgICAgICAgYmluZGluZ3M9MCwgYmluZGluZ3NfYWxsb2NhdGVkPTANCiAgICAg ICAgICAgICAgICAgcGFyYW1ldGVycz0wLCBwYXJhbWV0ZXJzX2FsbG9jYXRlZD0wDQogICAgICAg ICAgICAgICAgIHN0YXRlbWVudF90eXBlPS0xLCBzdGF0ZW1lbnQ9JyhTRUxFQ1QgInN1Ym51bSIg IEZST00gInN1YnMiICkgVU5JT04gQUxMIChTRUxFQ1QgInZudW0iICBGUk9NICJ2ZW5kIiApJw0K ICAgICAgICAgICAgICAgICBzdG10X3dpdGhfcGFyYW1zPScoU0VMRUNUICJzdWJudW0iICBGUk9N ICJzdWJzIiApIFVOSU9OIEFMTCAoU0VMRUNUICJ2bnVtIiAgRlJPTSAidmVuZCIgKScNCiAgICAg ICAgICAgICAgICAgZGF0YV9hdF9leGVjPS0xLCBjdXJyZW50X2V4ZWNfcGFyYW09LTEsIHB1dF9k YXRhPTANCiAgICAgICAgICAgICAgICAgY3VyclR1cGxlPS0xLCBjdXJyZW50X2NvbD0tMSwgbG9i al9mZD0tMQ0KICAgICAgICAgICAgICAgICBtYXhSb3dzPTAsIHJvd3NldF9zaXplPTEsIGtleXNl dF9zaXplPTAsIGN1cnNvcl90eXBlPTAsIHNjcm9sbF9jb25jdXJyZW5jeT0xDQogICAgICAgICAg ICAgICAgIGN1cnNvcl9uYW1lPSdTUUxfQ1VSMDJEQzM5MTQnDQogICAgICAgICAgICAgICAgIC0t LS0tLS0tLS0tLS0tLS1RUmVzdWx0IEluZm8gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LQ0KQ09OTiBFUlJPUjogZnVuYz1TQ19leGVjdXRlLCBkZXNjPScnLCBlcnJudW09MTAsIGVycm1z Zz0nRVJST1I6ICBwYXJzZXI6IHBhcnNlIGVycm9yIGF0IG9yIG5lYXIgIigiJw0KICAgICAgICAg ICAgLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tDQogICAgICAgICAgICBoZW52PTQ5MDIxMDYwLCBjb25uPTQ3OTcyNDcyLCBzdGF0dXM9 MSwgbnVtX3N0bXRzPTE2DQogICAgICAgICAgICBzb2NrPTQ5MDIxMDc2LCBzdG10cz00OTAyMTEx NiwgbG9ial90eXBlPS05OTkNCiAgICAgICAgICAgIC0tLS0tLS0tLS0tLS0tLS0gU29ja2V0IElu Zm8gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KICAgICAgICAgICAgc29ja2V0PTI0 MCwgcmV2ZXJzZT0wLCBlcnJvcm51bWJlcj0wLCBlcnJvcm1zZz0nKG51bGwpJw0KICAgICAgICAg ICAgYnVmZmVyX2luPTQ3OTc4NzY0LCBidWZmZXJfb3V0PTQ3OTgyODY0DQogICAgICAgICAgICBi dWZmZXJfZmlsbGVkX2luPTIsIGJ1ZmZlcl9maWxsZWRfb3V0PTAsIGJ1ZmZlcl9yZWFkX2luPTIN CmNvbm49NDc5NzI0NzIsIFNRTERpc2Nvbm5lY3QNCg== ------ =_NextPart_000_01BE9308.0D437A20--