Hilmar
Thanks a lot again but I'm afraid that made no noticeble difference, i.e. it's still taking longer than the age of the Earth to run. I tried as below. The table's composite key comprises: RTE_NO + Rte_Let + DIRECTN
I did find out why one attempt seemed to go so fast though, on Friday. Note the second commented out line; it has a continuation ";" at the end, so the compiler was just ignoring the SQL as comment and it wasn't being done (I left it in to show - in the run it wasn't there of course).
So back to the drawing board ...
Terry
...
Select DISTINCT TIME from RZStop ;
where PADR( RZStop.RTE_NO, 6) + RZStop.Rte_Let + RZStop.DIRECTN + STR( RZStop.Number, 3) + ;
PADR( RZStop.Stop, 8) + PADR( RZStop.County, 2) = ;
lcRteNo + "A" + lcDirectn + lcNumber + ;
lcStopNo + lcCounty ;
and not EMPTY( RZStop.TIME) ;
to SCREEN NOCONSOLE
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.