Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC - Access allows numerials to begin fields but VFP d
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00666706
Message ID:
00666708
Vues:
22
Mike,

I'm not sure if this will help, but what happens if you make a view as SELECT * FROM table? Do you get an error as well?

Another try might be to make a SQL-PT connection and use SQLCOLUMNS() on the affected table. I wonder, what will be returned as the field name for the "numeric" field name.

HTH,
Armin

>The problem recently came up is that VFP doesn't allow numerial to begin fields but Access does. Thus when we use a remote view using ODBC to connect to the access DB, we get an error when we include a field called '5_percent_n' We can't figure out how to get around this, as we want this to work programmatically (ie changing the name of the field in access isn't really a viable solution)

Armin Neudert
Regional Director (Stuttgart) of German FoxPro User Group dFPUG

MCP for Visual FoxPro

Expert/Editor of the VFP section in the German Codezone community portal
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform