>>join can to be faster but it is formally incorrect.
>>if you use c_temp here once only, doesn't index it, vfp does this in a faster way
>
>Are you sure I don't have to index this c_temp cursor? I added the index today in the morning, it seemed to degrade performance...
>
>Thanks.
put TimeToStr(dtot(m.tdDate+1)-1) out of the query, into a variable,
or directly into the lcFilter string <
>
usesEmployee_queue_schedules.tScheduled_time < ] + ;
<<TimeToStr(dtot(m.tdDate+1))>> + ;