Hi All,

I have a program that had been running just fine for almost 3 years. Then on Friday it began to hang. 1 of the querys would no longer execute. It is a simple little query. The following is executed through SPT to a VFP database.

SELECT ALLT(PERS.last_name) + ', ' + SUBSTR(PERS.first_name, 1, 1) AS full_name, EMP.pers_no FROM EMP LEFT OUTER JOIN PERS ON EMP.pers_no = PERS.pers_no WHERE EMP.hrs_base == 1

I found out that now I have to add the following ORDER BY clause to make it execute.

ORDER BY PERS.last_name, PERS.first_name

Ok, I probably should have had this there already. But why all of a sudden does it demand it to work? We've done no serious upgrades to the database. The ODBC driver's haven't changed in a while. What gives???

TIA
Mike

P.S. VFP6 SP5