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
29/06/2001 09:00:18
Steven Herbin
SNH Computing Corporation
Swan Lake, New York, United States
 
 
To
28/06/2001 16:30:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00524748
Message ID:
00525127
Views:
16
>Yes, surround the entire source field name in quotes. In the remote view, though, make sure it maps out to a field name without quotes. After you have created the view, run GENDBC and make any changes as required to the output code and re-run if you have to.
>
>>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.

I got some feedback from the ODBC author. He gave me some debugging tips which I'll work with over the weekend. I just wish the feedback from VFP were a bit more meaningful.

Thanks for your help.
Steven Herbin
SNH Computing Corporation
Swan Lake, NY
Previous
Reply
Map
View

Click here to load this message in the networking platform