Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Correct Coding for a Field with a SPACE in its name
Message
From
28/06/2001 11:41:10
Steven Herbin
SNH Computing Corporation
Swan Lake, New York, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Correct Coding for a Field with a SPACE in its name
Miscellaneous
Thread ID:
00524748
Message ID:
00524748
Views:
41
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
Next
Reply
Map
View

Click here to load this message in the networking platform