Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange char in column name
Message
De
16/09/2014 05:46:25
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
16/09/2014 05:44:38
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:
01607603
Vues:
47
>>>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.

Last time I was reading ODBC documentation was about 1994 :).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform