Try to build the whole select statement as a string instead using SET TEXT TO lcSQL TEXTMERGE NOSHOW command.
And no, I didn't see Borislav's response before posting <g>
>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
If it's not broken, fix it until it is.
My Blog