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