>Hi all,
>I installed VFP9 on the windows where VFP8 was installed and was compiled my application in the new version without any errors.
>But on runtime I am getting error :
>SQL: ORDER BY clause is invalid
>
>for the next command(it works fine in VFP8):
>
> select min(tu51.f01) from tu51 into array __ttt ;
> Where f26 !=1 and tu51.f23 == g_emp_dep;
> order by tu51.f01
>
>If I change this to:
> select tu51.f01 from tu51 into array __ttt ;
> Where f26 !=1 and tu51.f23 == g_emp_dep;
> order by tu51.f01
>
>it passes without error.
>
>
>Why?
I'm not sure about the error, but without group by your first statement doesn't make much sense anyway. You're selecting just one record (or 0), why do you need to order it?
If it's not broken, fix it until it is.
My Blog