>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?
Why do you need to order it if you want to select just one value?
Edward Pikman
Independent Consultant