>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

Probably formerly first pulled record had a corresponding name now null.
Cetin