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 16:30:11
 
 
To
28/06/2001 11:41:10
Steven Herbin
SNH Computing Corporation
Swan Lake, New York, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00524748
Message ID:
00524899
Views:
15
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.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform