Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange char in column name
Message
De
14/09/2014 05:49:04
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Strange char in column name
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:
01607500
Vues:
84
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]
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform