Fwd: VB6, ADO returns EOF via ODBC but has records inPSQL
This is a discussion on Fwd: VB6, ADO returns EOF via ODBC but has records inPSQL within the pgsql Interfaces odbc forums, part of the PostgreSQL category; --> >I'm trying to find the set of records that are not in a comma delimited >list using an SQL ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-16-2008, 02:10 AM
| ||||
| ||||
 Fwd: VB6, ADO returns EOF via ODBC but has records inPSQL >I'm trying to find the set of records that are not in a comma delimited >list using an SQL statement like: > >SELECT name FROM construction WHERE name NOT IN ('a1 ', >'a2 ', '') ORDER BY name; etc... Try select RTRIM(name) ... where not in ('a1', 'a2') etc VBS/ADO acts weird with trailing spaces. Maybe there are other solutions too? - Johann      |
Linear Mode
