Hi All,

I know that this has been discussed, but when I searched on this title, none of the results seem to answer my problem. My sql string looks like this:

SELECT &alist[1]&alist[2]&alist[3]&alist[4]&alist[5]&alist[6]&alist[7]&alist[8];
 FROM &cFile_list ;
 WHERE &aConds[1]&aConds[2]&aConds[3]&aConds[4]&aConds[5]&aConds[6]&aConds[7]&aConds[8] ;
  .AND. &aJoin[1]&aJoin[2]&aJoin[3]&aJoin[4]&aJoin[5]&aJoin[6]&aJoin[7]&aJoin[8] ;
 ORDER BY &cSort_set INTO CURSOR (cTable_name)

I am going against native tables. I did not have this problem in vfp6 until now.
Please help,
Thanks,
Beth