Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange char in column name
Message
De
16/09/2014 05:44:38
 
 
À
16/09/2014 05:26:10
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01607500
Message ID:
01607602
Vues:
42
>>Use back quotes `:
>>
>>SQLEXEC(m.lnODBC,'SELECT Cur1.`Field "C"` AS FieldC FROM myTable AS Cur1')
>>
>>This is the standard approach for Microsoft ODBC drivers when dealing with column names that contain characters others than simple letters, numbers and underscores.
>
>Standard? I saw that only once, in 2006, on MySQL... never on anything Microsoft. I assumed that brackets were used for it, probably because my database experience (not in the microsoftened sense of the word) is 99% TSQL and 1% other.

"Standard approach for Microsoft ODBC drivers" means exactly what it says: it's the way Microsoft ODBC drivers (Excel, Access, dBASE, text, whatever) deal with column names.
----------------------------------
António Tavares Lopes
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform