VB6, ADO returns EOF via ODBC but has records in PSQL

am 19.10.2006 19:00:25 von Erika Marlow

This is a multi-part message in MIME format.

------_=_NextPart_001_01C6F3A0.129D9BF9
Content-Type: multipart/alternative;
boundary="----_=_NextPart_002_01C6F3A0.129D9BF9"

------_=_NextPart_002_01C6F3A0.129D9BF9
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I'm trying to find the set of records that are not in a comma delimited
list using an SQL statement like:
=20
SELECT name FROM construction WHERE name NOT IN ('a1 ', 'a2
', '') ORDER BY name;
=20
The values in the field are padded with spaces and I have to keep them
that way for data integrity between software systems. If I send this
statement to the PostgreSQL database with ADO via the ODBC driver
(adoRs.Open sql, dbconn, adOpenStatic, adLockOptimistic) I don't get any
records. However, if I execute the same statement in psql directly, I
get nineteen rows.
=20
Is there a property setting or something that I'm missing when using the
driver?
=20
Thanks,
=20
Erika Marlow___________________
Senior Software Specialist
National Information Solutions Cooperative
One Innovation Circle
Lake St. Louis, MO 63367
**Email: erika.marlow@nisc.coop =20
**Phone: 866.WWW.NISC (866.999.6472)
**Direct: 636.755.2519 =09
=20

------_=_NextPart_002_01C6F3A0.129D9BF9
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

charset=3Dus-ascii">

I'm =
trying to find=20
the set of records that are not in a comma delimited list using an SQL =
statement=20
like:

size=3D2>

SELECT =
name FROM=20
construction WHERE name NOT IN =
('a1 ',=20
'a2 ', '') ORDER BY=20
name;

size=3D2>

The =
values in the=20
field are padded with spaces and I have to keep them that way for data =
integrity=20
between software systems. If I send this statement to the =
PostgreSQL=20
database with ADO via the ODBC driver (adoRs.Open sql, dbconn, =
adOpenStatic,=20
adLockOptimistic) I don't get any records. However, if I execute =
the same=20
statement in psql directly, I get nineteen rows.

size=3D2>

Is =
there a property=20
setting or something that I'm missing when using the =
driver?

size=3D2>

size=3D2>Thanks,

title=3D"NISC Homepage - www.nisc.coop" =
src=3D"cid:163465316@19102006-36C7"=20
border=3D0>

Erika=20
Marlow___________________
size=3D1>Senior=20
Software Specialist
National Information Solutions =
Cooperative
One=20
Innovation Circle
Lake St. Louis, MO 63367
color=3D#e70042> face=3Dwingdings>+ Email: href=3D"mailto:erika.marlow@nisc.coop" color=3D"#999999"=20
erika.marlow@nisc.coop
color=3D#e70042> face=3Dwingdings>( Phone: color=3D#999999>866.WWW.NISC=20
(866.999.6472)
face=3Dwingdings>( Direct: color=3D#999999>636.755.2519=20
=

------_=_NextPart_002_01C6F3A0.129D9BF9--

------_=_NextPart_001_01C6F3A0.129D9BF9
Content-Type: image/gif;
name="nisc.gif"
Content-Transfer-Encoding: base64
Content-ID: <163465316@19102006-36C7>
Content-Description: nisc.gif
Content-Location: nisc.gif

R0lGODlhfgBbAOYAANmvrMU1TDAwLMlFU9zb28zLy769vLS0tJ1rb/DOx6kC OfT09PHx8Z2dne/v
7+ezqcPDwpKSkujBu5ACMLwDQaKioklJRIuLioGBgODg4KuqqoaFfE84N3V0 dGJkWvv7+1MCGHJy
avr6+ubm5nt7e2tra+np6ZOSiWJiYtXV1ayMi9JoZ3cCJlxcW/j4+NDQ0KOi mltcU1RUVOSlmm9R
Ubazrdh6dlNTTd2LgkVDPm1tY52blNjGxMF5guGaj/fp535+dNuDfMMkRqqp pYuKgN6TiMxUW7q5
uNmUlV5GRUADErCvrcaal7ZCXfn089VxbL8JQ14rMdWno+DQzY+PjvLk4vjx 78jIx/Pc2KempBwc
GZeXlc5gZIaGhkQgIqMwTXkcMn5hYSYnI9jU1OPj4/39/WEDHfv4+Ozr6tPS 0tjY2MCWjv///9Fv
ek5OSv7+/mZoYV9gVldYUzs8Nnd3bXcxPff3982hoOrq6MuJiuzs7KURQNfW 0vn5+d+goMAURSH5
BAAAAAAALAAAAAB+AFsAAAf/gGyCg4SFhoeIiYVvjB8fIn0udgsLDJaXDpkO l5aUC3YufY4fjG+K
p6ipqquJpY59VlUJEg8zPkVBQTa7vLtBOEh+DxJTIyZ4epuUdqIfZYys0dLT h4xlH30/CbVFOLm8
T08r4+TjXOfo5yttSABTZMbJDJ/NpdT3+NVv11ZY3DjebIg7Z8TIgIMDAgRI qBDhwYIQIXKxIWVK
BnholLlwZC+fx2jWnPi7FfAJF4MJhaj8AwUKBQouYcZs+eePSiENHyLkkocH gQzGNDqD9rFoqzcf
fkiYUQSXjRUGA6iM+bKq1atYYcpUmROhkZ5qgOJx8EkEKVNG07KxNtIHjqcG /4WwpJq1rl2sUGzi
VKiQy50xP0fomSfqGVq196xVqeUjyJO4f17SvUs5qwIKCi5fhrlX6oA8L1IQ IINm3sZniKnt+8E4
CFSpkyvLxpx5gu3buG1nfnkzQA8eaUbjIXw29SpGThLYwvE4AMvZ0GvbZsHC jBkQ2LODsG6GOgvd
FPT2KBCcNAM7Zokab1XGH9Pmz6FXrk39upL7Srx44ZAkR5IbSQSYBAdRWEfd BLvlxQR5BAh23lDr
IfLGGco1xgVs8lFGn3337ZeDG3LI0QIKI8JRwokhdKCiimHQUMeBmzUBQAEp AEWWKOpFyAhr7w0g
RGwZWqXAdCB0yIEFbsggIv8KKJyoIgkkYCBlF1RWaSUCLyKoABQ9XPHCaIPZ AaGOb7gXxIWRBVnX
kBOYgZ8XFiApw4glpBhlFxdEsMUWDTRQwZ9/9tnAnlvouQUCYCBIQRMG0JiB CTcWlxoj2/hggxE/
qmnZBNUZ6cYNczYZwp1U8FmBBksccMARBrTqqgFHqLqEBhoEWsEJX2QGBRNX BDcCWRvlWNQ+2xTx
hI9ABplZp/nlICedHWCQp58arAoBBFcU8EIaKXTrbQovvFDAFdfGesCsQ6iQ qwJdfkmGHgsEe9hH
xDK1gnOaXlWbm81aACoKcHRAQhdUNJDFEqxmm4YaP100gjEmRPzwCGRkQAD/ AeCOC4EBqh6gwh4K
GOElmAycNi8+xD5QxL1p5vvSkCwUud+zdZJwwRanHmCAlwzDY4I883gidCUM OICGCRVj/AK5rR6B
gAJNaEuyyR7Vu3IAycq3LL8cfDhnwDbjjDAEL/T8c9ChmOVIGWyzPYoIklRi 9AgWZ3ztHXt8QSOY
8UqaWLH3Zh0dpx3GGWoJYVewxM7lnR2vWYadbIgr2EziAB50q5HG0lc08UXZ NvYtLCtlqhy4y7S1
eZ+zILZQQgddRKB4o6KNUNrjZ0meijUfuFCJHhRjnEYBPTQh2qPzpKcaaz48 ga/LyxZuQajRFrz4
FTU6yMxQukvTiAh2FI00/wFqpMBED2E5KK/3TixlwwAtazok13I2GfYQR0Dg a5jpdY8yUuATX9IA
cIeLDAc9qAGJcoLgI9QNSWbO+loIMCC7A5CNZOjx26QAGD49IC0D7xjBWBaA I5BgYQY4GEBMNsPC
l7kQMy5cFgST5DrYbUEDR8BeBg7YvwgRYh+9+50JHua4YJHuB80TAptyw8Qm 4oZ+SbJfwSz4pV+R
UIM+FEQjglg0Pchje6NrBQ4CoIDqcOeMaEwjGoukBK+1IGCxy0IOU2AeqmVR QtfowyQqQQkX9FAV
P2hDDxCAgDC0iAYC4oAiF8nIRjLyBi2gU9gWV4AGRSqMdxzEFiMBCj+OSf8V SFmAHghwhQNUgAoY
6MCJVsnKVroSRVGy3gVNcB4RJDCTiuDdKNaGyWqUwQUMGIEaSlmBLVxASshM pjKhxEwoTalUB2sU
30xWCl3u8prOiJw+rInNXUauFG2rJiixIUoypOAKR9DAoCLAzj0J6p2DKlQE qEAFdh5MA0NA1RKG
kAU6Dqdvb4sbJTjBCU+AgpfVvAbc9kg0gnZiGZ7kXkdU4YAjDGEHJzjBnk6w AQ/grAJZQNWqjpA/
i2L0BECIgwf8lAUD1AAGGSVCCCAZnEeRZQEmUEMBXLoEGPj0p0MYwhJqkD8C IMM0a3MEGgjwAggc
oQZZ+KlPs5BPnZHtUV//LIz/WkGAI2ThBEQIKxE2MFM4hBRhO9OWuLwKViDE YA5mrdYQtgCEEIQA
Dm4QAAmyVaMMXAGqMNjBFmIq1rFuYKx0iEEOthCYMC2ADH+NqmAJG9YNWFas G6BDHNzQgNFASnTS
KAMEloBSOpiWDiHwgBvmsIWD5fBLFzEAaVH7Vi10IWdE0EEMbnCDvGqhAasq wGiHAFMiAEEHcYhB
iJYbA5V64AZzEMBr1QCPF9SAuBg17l2TG6IbhKi5HtCBDuQQ3SMwyIoi2Go1 8PBSIMDBA/CF72bn
gILWHkCHmGsvHOJgATEIQE8VOEANBLyEr6rST6x6KUdDwN/oiuHBDxaA/4Tn MAcxaCEEqTKAuGrQ
0y0YFw5ysEB0BQBhEktYAHPIQQ4EoIUSjO1LtHRBGUCSBtKmNr7xvUEO5tCF GxogDe9Sw2w9QF4t
3EBarY3VXDsqgBIU7KkwyKxuLUBiNzSpTnZVZQv6+1+Dteq6HKXDcyusBS0I wA1vxHKKSoCCG7BY
DLKrFgSo6wAxqbcQIjBAFjaw3xj4Ob4xEDEcugDcKxgVAkPI7XNZjAKBCXas QDhuXqUl1Cjr4L1y
2HEzMYCnC9CTnZ6OAHBdCgMi0AEOin3zDaLF6U7Ts57sjAAJOmAqCwK5zh8g HRpqsAMgENkNn4oD
HPYL3Rx04AIV+DEZ9P/L3wc36dhZsKpFu3DsC/j0BHeFbwzcYIFVjorT9SSU OzXg0l6nVrEWNvaT
7hRqcbu7AXKmowNkTLoaYzvQc3BDcy/tgUALAAUk2MISvLSELYi5yHMYUQgE fq6vwmEOcqCSh48b
3zjI4QYxWHO0pvWnLHh8CLCCAcU3y+IbeDtKeeKTx2nF8pVXS5ojYEAf7kyI PO95vBWWAQo8EAId
eGC+Fjh2shGtaDcbeURUkC0MBksHN4ghBHjawrnB+3OV6oAOGNhAqaiVKlU5 dQgb4HeRc8AkE1XP
YKli1bWu9aprFYC68CLFcXbda9WyuAVyuHq2Mz2HEmBgC1B2b7PF8DX//H01 szGQMJVuRoTeAtu7
MfAAHEJAh0hHegMRSLsBrlXwU8PX6HN6Y7Rkdz1tdUsNqO9WGrjVs8EYEZQv sDF/zYz3DgCBDj7f
9hxkcOwjLGEHYq5twl3H4RPgPg45MLKUblaBBjw8xayTg7Apf9rUEkHtRyi1 z3/udAHIQOd+j4Ac
sRcYiEVsiBMzQUZAu4oP6DnsY48kCiKdbR13GwM10AC2F310FHRBv/zXaGFz MAfQAB2wWhT2IZEH
B+IlXs8VAqzye2EnX3klAN4VMFTQUpXkIEFjBww1NJ7US5NDd75mdPI3aLeX e9wmMD0VdoP3NYpj
cD/XX2JwIgPTAGjl/3sNcAEdgALcdgOS917Dtlk5cAE9hVLbN2b55joYAFyV xENr0zbXcE3adBz2
xmAWoAViwCSN1gUbUFfEdgMhsAFZQFeoNgdaMHwlcF2Kplhp+GzIZkEFIFym ZExSUle4B2hU1gJb
sANfmIR8h2ZQl2wpEHO2tFUTFQ1l8H44pwVkJ0W9lodxEAchcAELxn9ohgL4 J3LvZXRohoEamAKa
cwWylQUNEAE3Q1bvRWQVlgN/Z1pJGAc3YAEiAm0QUIgLcIjVtA/hlIjHwV51 Z3RywCSwg4MYAIbw
dXVgOHgiAgcxeGqb9WBzUgIEQ25fcjEpIFyxgipDYHzvtW0sZmxSsv+KgHZx cDAwFXAEL5AB8NJJ
LiAJmeCBocA93sMHskeDTII4EYBDIud5kidewyZ8IuJiiZZ7yed9fHhRMCCH qScuTPNSuWVxVFZm
MvA6XaBbfuZcPxdeQCBw+vMTSZMGBnACcJACXjQPGURzhbCIewZiaEhfTdKE FgQBKYhj8mV006OJ
AAhdWpCT+cdRh0UEGrUDRLkDPrUFfCYHq2VhPSkHcBQBIfB4GNdcDFh5hzWU grUnQKCUFwMUYSJ3
pDMCWUAEINZfWjCMjXYBLRUaDXBuvPWWPCkGIAIHWxBlRKZjFgYqF+CHl6YD IWB5gHl8OkZmZjY9
rkMCBVMBF6BjzoL/JBgneZQXmKeWV3KQLe4CL30wY6RzBG61Y2+WjwF3Xz9R ALK4YxR2mhbmfU1i
cHxHZgKgcKq1YyoWJ8AWJ6ZJYmUmBrsnf4hzAfCmKkPQBeSFYqfZmHFiAbdZ Zh1gLVVUMpq5Cn1A
BA2GmzngJMimbEO0AZ5JYhBWZmjmd3SQaRL2YFpgZedIAgzGbSMGYRGWYpC0 Iqt0dtdDLqZEBT3o
BtsZYRM2B9MDB6SXQ3RGb6xQBg4gTBBQgF3ATD02cAQAKXrgVwiqSkwSSSZi M9QyBKeYSh3wbaKW
T6a4BVRQJRfgafQ0ol2AAczEaRVENt2yNBbVAKjUTM7kap+mchYk/28Cehx9 wADmBAHqRAWe5mO3
Rgl4QAAFYEoRkKCzJjAE85uwcgBleExRpziyUivrFGux9mojGm6/CQF7Qz5N lU6DcgEnqkwiOqKi
Fm1zFnM5Cko7agJGmk6AsjhfggfxAkzChE7qJE96gnabNy4cY6XUYlUb43u1 Eijw5Cd/cgQAIAWO
6qgAEKmS+qh3cAdMcKlrkKmaugYqMEjsBG/m1aC5qJKa9AHlpFOFunkwVjKO YAcFaqROdS5LoHk8
g3pL41Qk9aehsTlMYy4d86skxQNMIRDhUKzGeqzIGg5QQQETUAcFo6ZApgd2 BhK9wwB6QAbCExo/
QUtiwjYisAAFmv8BmiMuc2h6IEkxdRMuodEzZJA041qu4wKvL8ADD2ApJxER +Jqv+kpGLKAEJCBq
OFRJtJSZpLoWHCQ+FOMz/GMYj9BBQ1QxGRCxCrsJDuBBCTuxmaAHR4OuEdux ErsUzZMSNzGyJFuy
N8GsbkIDsYODGsaOCwCWqVAFuqRHA3UJ9AAhvBM3lqAJDyWPe0RQECUJP1s0 mpAJi2EvDQQ9bhIF
G4eDt0gGzkmqEpAAb9MHVtsHIqA2CPVDQOQIWfu13fQ2WptNbbNLWRsJLjAS Z4I1DtSvXoACo+Kb
A6cGJjCqAyoMCwUK9SCCPlQK7WMLl5Ip0NOvSmBlr+ObB1BJcUf/qoxwBjaA BJPQgVqFS5PTHrWA
AyuALA40AUXCAV9jM+n4AmQwbzCLCo3gBFzQBlXgRUKBRVnECFYAskFgBM8D PZyrBEcCSX7nkXSb
i7e0O9jwAwYhAUQ0GH3zu2RCIZd7LIJruzKDJHKAOBmobKRbsGtROVVwITYA kmeTktYLEkjhHkVw
KbXrvPkBvWkZui5buqBUBgFkAhcyAFLAvZvgvYjRCEfbGJnbvOYLJ1F0bE5o VL77vY3gO8CTBzhh
BABgNvX7R/lgDSKQv67hI/GTLzJ0vv9LaKIZY+x7HI9QCSaQAXdgEwPABQBw MfBgvNQ0Da4gEvXa
GPAhONFRRvdx/yQg0oWFpgZs2sHHgRS+E6480AQUsBBGcAdTEBgjtD25cwrg 9AFnUAUgiwuvER+o
gxmqg7tIMiLFuARr+iDfuwg+XE4Y0wNbshAD0AYVERgZgZIRRbZu47V9IBJR /BaZ6xwyPMMx0y/T
CMAWpMO4xre7cw3AdK0EkAZHkCtD/BDs4A7tqn6bEDRDswBogAW0cAvdIBCQ cceDQ7he4Ea9GWBX
4Md29sW+VK2EnAZX8DGXIQQDIBErEARIIAXDQAwSUMsP8AB+0A0A8Q1QkRKa vMlsFEHDOEEVFMq/
MsppUcBijMoGgADgQcRGoA7jEA690AsDQbsYUsVCwin84r973P9j+LOBXkzK uRTGr8rMNeDM4IET
D1EQ6XCvByEVP/LLWmMb3ew1w9ibLLuqyLxB5OQAIZyNB6oBiHIbu6EXJTsX 2mwZMHPP05PPsLOi
NTIc66Mj19BB2BqmBYYl36Ebu7HQGsImedwswBZJr4MB1tMocHdFgEwvSNEH 4Eo32QgrtXICYQAG
B+LRmwHStCHS/ILBSvJsSDYEtoY8CETOqnHR1joChUyKUDooG0ADOJ3TOr3T M5wZPv3TnZwkS3LS
N6Oml3m8SJ0YB4sGGU2KBXaKxxQGdQAG3eEdTITVci3XuVEf2NEhnQwqXf1t 0KQzb4c8uei6lNsI
MM0AeICtzHz/AHtKprMWBklQINzhHZI92QZiHXdtJBzwKUsiKtGysnLmKFZk R5SLR1xk1hijjWlt
TEqqSnGASFEQBV7ARvgx2/qxH7mrJPJ3ZQIjLaKmOPnz16FNj6Ndznn0O3RT yKhtpah4okvKSnDA
hdA9ItDtbU8CbqaSYTxjU2Uh2MMtIRwErpgjrsOzMedipYVCpmXKTCuy3gKT oovXpzmTPzzjWcDC
EWOdSTkrN0OUrsL1pLOSBc0XT1g64IbSJyAlUmqnLWajwsLd3aqxRb5TNGiA ruSzOcK1MU/aMbO6
4V2nKrl6LV6yMNyrwpDT0g6+O5sUuRX7sBZTPuASLvAa42q1Ui2ieK4/oxEl ft8n7t1TSLNyowd4
gH7t6rFEfhHwYAzIoAzxsrc6vuMojhSvIFANtbM8C7SfkDb23eRO/uDc5LVf m7XYxDa+uOVkXuZm
fuZnHggAOw==

------_=_NextPart_001_01C6F3A0.129D9BF9--