How do I extract data in a Visual Basic client program (using RDO) from informix database and dump them into a file using unload in SQL statement e.g. "Unload to 'c:\mydata.txt' select......".
I have tried many times, but there is always a complaint saying "a syntax error in SQL statement", but
when I run the same SQL statement in SQL Editor 2.0 (Informix client SQL tools), it does go through.
Do VB5 allowed direct dump of data through ODBC???
Basic info:
Informix Universal Server 9.14
Visual Basic 5.0 Professional version
Through ODBC driver INTERSOLV3.10 32bits
I have tried many times, but there is always a complaint saying "a syntax error in SQL statement", but
when I run the same SQL statement in SQL Editor 2.0 (Informix client SQL tools), it does go through.
Do VB5 allowed direct dump of data through ODBC???
Basic info:
Informix Universal Server 9.14
Visual Basic 5.0 Professional version
Through ODBC driver INTERSOLV3.10 32bits
