Good Suggestion Dragan,
I've changed my approach from:
m.lcPath = AddBS("C:\December 1998")
m.lcSQL = [SELECT * ] + [FROM ] + ForcePath( "entry.dbf", m.lcPath ) + [ INTO ARRAY aFees]
*-- Execute SQL statement
&lcSQL
TO:
m.lcPath = AddBS("C:\December 1998")
*-- I've added a WHERE clause ONLY for clarity
m.lcSQLWhere = [vendor="] + m.cVar + ["]
SELECT * ;
FROM ForcePath( "entry.dbf", m.lcPath ) ;
WHERE &lcSQLWhere. ;
INTO ARRAY aFees
This seems to do the trick without much re-engineering.
Thank you for your suggestion.
P.S. It has been proven that my initial approach WILL work with both Win95 & Win98 but NOT with Win NT 4.0. I do not know about NT 3.51.