Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange char in column name
Message
From
16/09/2014 05:46:25
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
16/09/2014 05:44:38
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01607500
Message ID:
01607603
Views:
48
>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform