Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Correct Coding for a Field with a SPACE in its name
Message
De
28/06/2001 11:41:10
Steven Herbin
SNH Computing Corporation
Swan Lake, New York, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Correct Coding for a Field with a SPACE in its name
Divers
Thread ID:
00524748
Message ID:
00524748
Vues:
42
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform