Information générale
Titre:
Why does my query hang?
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement