Re: Query vs. time

SaTriGuy wrote: > > >Have a problem over which I've been slaving for two days. I [SNIP] > If the performance is better, then you could be getting much better performance > by comparing against a datetime variable in which you have already calculated > the two datetime fields. > > 7.11 is quite old at this point. If I can remember correctly, there was a > problem at one time in which we were re-evaluating the datetime field in a > query like this. It might be worth it to consider moving to a more recent > version. Yes prior to 7.12 the engine converted each row's datetime column to a string and did the comparison as a string compare. Version 7.12 fixed this to convert the literal string to a datetime and compare directly. the workaround in ESQL/4GL was to convert the date string to a DATETIME in the program and use that datetime host variable in the where clause. Art S. Kagel