I am doing some work with an ODBC data source "LinkBook" (using a 3rd party ODBC driver). This driver allows you to access QuickBooks files. When it generated the code for the remote view, I noticed that the field names for the QuickBooks file were coded ' filename."Field Name" ' (no outer quotes) for the fields with spaces in their names (Address 1, etc.).
When VFP tried to execute the SQL statement it abended on an illegal name error (or something similar).
I was just wondering if the entire ' filename."Field Name" ' should be surrounded by quotes as in "filename.Field Name" ?
Thanks in advance.
Steven Herbin
SNH Computing Corporation
Swan Lake, NY