>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.
Why not simply open the table first and reference it by its alias?
George
Ubi caritas et amor, deus ibi est