
Visual Query cannot execute query to dBase
Submitted by admin on Tue, 2009-04-21 15:15.
Win9x
Microsoft ODBC dBase driver
There was persistent error "Invalid..." when try execute SQL query using Microsoft ODBC driver to dBase table named "xxstat_w.dbf". The queries to other tables work OK. Problem causes underscore in file name. (but filename "xxstat_w.dbf" is OK). Renaming to "xxstat-w.dbf" and problem is gone.
Win9x
Microsoft ODBC dBase driver
There was persistent error "Invalid..." when try execute SQL query using Microsoft ODBC driver to dBase table named "xxstat_w.dbf". The queries to other tables work OK. Problem causes underscore in file name. (but filename "xxstat_w.dbf" is OK). Renaming to "xxstat-w.dbf" and problem is gone.