Michel
Shouldn't "order by" be the last clause of the SQL, after the "into", or doesn't it matter?
Terry
>The following doesn't work anymore in VFP 9:
>
>
>SELECT *,Numero AS OrderMain FROM Message INTO CURSOR Temp READWRITE
>INDEX ON STR(Numero)+STR(Ordermain) TAG OrderMain
>SELECT DISTINCT Numero FROM Temp ORDER BY OrderMain INTO CURSOR Temp2
>
>
>It says SQL: ORDER BY clause is invalid
>
>I am trying to localize the problem and I also need to find a workaround. If someone has an answer right away, that would be appreciated.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
