I just can't seem to figure out what I am missing. Any suggestions?


lcDirectory = "C:\AMP\SIS1\"
tcCursor = "Report"

SELECT fchkno,SUM(famt) AS Check_Amt,;
fchkacc,;
fchkdate,;
fcompany,;
fvendno,;
finvnum;
FROM (lcDirectory + 'APCHK01') ;
UNION ALL;
SELECT fchkno,SUM(famt) AS Check_Amt,;
fchkacc,;
fchkdate,;
fcompany,;
fvendno,;
finvnum;
FROM (lcDirectory + 'APCHK01H') ;
group BY 1;
into cursor tcCursor