>sorry it end up with ". its just for illustration purposes.
>
>cSelectStat = "select "+lcfields +;
> " FROM a "+;
> " left Join b On b.fieldpk = a.fieldfk "+;
> " left Join c On c.fieldpk = b.fieldpk "+;
> " left Join d On d.fieldpk = c.fieldpk "+;
> " left Join e On e.fieldpk = d.fieldpk "+;
> " left Join f On f.fieldid = e.fieldpk "
>
>&cSelectStat into cursor curtemp readwrite
>select curtemp
What are a, b, c, etc. ? Can you use real names of the tables? And also try my advice of TEXT/ENDTEXT and try running this command in command window. It may be a typo/error eaten by your error handler.
If it's not broken, fix it until it is.
My Blog