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

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

From
"Johann"
Date:
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