>Hi Naomi
>
>>Show your final select.
>
>The same Sergey suggested but 2 more fields in the GROUP BY, the 2 fields belonging to the UDF. While opening the SQL it asked for a database which I provided and it worked. Later in the run time it started giving the repeats of GROUP BY missing or invalid.
>
>>Are you sure VFP9 run-time settings are the same as in IDE (SET ANSI, SET DELETED, SET EXACT, SET ENGINEBEHAVIOR, etc.) ?
>
>Yes as before, just ENGINEBEHAVIOR was 90 for Sergey's code (app and IDE) now I have made the app work in EB 70 and switched to the old SELECT.
Can you open the database and all tables involved in advance?
But anyway, since you're using UDF in Select statement, it may behave unpredictably.
You may still want to post the exact select + UDF code, so we can help figuring out what's wrong.
Otherwise you may leave the working 70 solution, perhaps it's not worth the trouble.
If it's not broken, fix it until it is.
My Blog