Обсуждение: VB6, ADO returns EOF via ODBC but has records in PSQL

Поиск
Список
Период
Сортировка

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

От
"Erika Marlow"
Дата:
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;
 
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.
 
Is there a property setting or something that I'm missing when using the driver?
 
Thanks,
 
Erika Marlow___________________
Senior Software Specialist
National Information Solutions Cooperative
One Innovation Circle
Lake St. Louis, MO 63367
Email: erika.marlow@nisc.coop
Phone: 866.WWW.NISC (866.999.6472)
Direct: 636.755.2519
 
Вложения