Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Syntax..SQLEXEC() using ODBC table with a space in the name
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Syntax..SQLEXEC() using ODBC table with a space in the name
Divers
Thread ID:
00459586
Message ID:
00459586
Vues:
76
I can't pass an SQL statement due to a syntax error when I use SQLEXEC(). I've connected (using VFP 6)
to an Access 97 database with a table called 'Budget Contract'. I would love to rename the table, but it won't
be possible. Here's the problem...

X =SQLEXEC(nh,'SELECT * FROM "BUDGET CONTRACT"') && works fine as long as the double-quotes are
&& within the single quotes, but not vice versa

X = SQLEXEC(nh,'INSERT INTO "BUDGET CONTRACT"(EMP_NO) VALUES('9999')') && won't work
&& because it won't accept any quote or space
&& between the table name and EMP_NO field.

Both VFP commands work well when I rename the table with an underscore in its name. Any help would be
appreciated. I thank you in advance.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform