Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange char in column name
Message
From
14/09/2014 05:49:04
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Strange char in column name
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:
01607500
Views:
86
Hi ALL,

I need to read / write to an ACCESS database.

I run into follwing:

A column is named, as reported by SQLCOLUMNS(...,'Native'), Field "C".

How do I adress this in a CA?
SELCTCMD is like 'SELECT Table.[Field "C"] FROM Table'
I get SQL error 1526
Error in expression Table.[Field [C]]


So something maps "" to [] but obviously it's not in the acces table.

Please don't argue about the field names. It's not a design of mine ...

Thanks

Lutz
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Next
Reply
Map
View

Click here to load this message in the networking platform