Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Macro substitution of SQL statement
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00168161
Message ID:
00168168
Vues:
24
Hi Juan,

Whenever long filenames/paths are used you need to enclose them in quotes. Try the following:
m.lcSQL = [SELECT * ] + [FROM "] + ForcePath( "entry.dbf", m.lcPath ) + [" INTO ARRAY aFees]


>I have been using the following code for quite some time without any problem. However, if the path has an embedded space, it bombs out with a "Command contains unrecognized phrase/keyword".
>
>m.lcPath = AddBS("C:\December 1998")
>m.lcSQL = [SELECT * ] + [FROM ] + ForcePath( "entry.dbf", m.lcPath ) + [ INTO ARRAY aFees]
>
>*-- Execute SQL statement
>&lcSQL
>*-- or
>EVAL(m.lcSQL)
>
>Any suggestions.
kenweber
GCom2 Solutions
Microsoft Certified Professional

Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform