>>>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 <>
>
>uses
>

>Employee_queue_schedules.tScheduled_time < ] + ;
>	<<TimeToStr(dtot(m.tdDate+1))>> + ;
>

It's already translated, see:

lcFilter = m.lcFilter + [Trans.cResolution_Codes_fk is Null ] + ;
	[ AND Employee_queue_schedules.tScheduled_time <= ] + ;
	TimeToStr(dtot(m.tdDate + 1)-1) + ;
	[ AND Trans_employees_queues.iActive_Flag = 1 ] + ;
	[ AND Employee_queue_schedules.iActive_Flag = 1]

In run-time it would be:

tTime < {^2005-10-05}, e.g. the actual date and time.

If it's not broken, fix it until it is.


My Blog