Hi !
I use a query like this :
for each Kunden
where (Kunden.k-nr ge int(Kunde-Feld:Screen-Value))
and (Kunden.k-nr le int(Kunde-FeldBis:Screen-Value))
and (kunden.kto-gesperrt = false ) no-lock .
ASSIGN StatusFill:Screen-Value = "STATUS : Suche nach Kunde: " + STRING(kunden.k-nr)+ "/" + string(kunden.name1).
find first lfschein where lfschein.k-nr = Kunden.k-nr
and lfschein.versanddatum >= ChVon
no-lock no-error.
.....
This result comes slow.ChVon greater or equal than the actual day.
When i use "today" instead of >= ChVon the result comes much faster.
But i cant use the today function, because i my query i have to over more than days.
What can i do ?
Thanks for help.
Make
I use a query like this :
for each Kunden
where (Kunden.k-nr ge int(Kunde-Feld:Screen-Value))
and (Kunden.k-nr le int(Kunde-FeldBis:Screen-Value))
and (kunden.kto-gesperrt = false ) no-lock .
ASSIGN StatusFill:Screen-Value = "STATUS : Suche nach Kunde: " + STRING(kunden.k-nr)+ "/" + string(kunden.name1).
find first lfschein where lfschein.k-nr = Kunden.k-nr
and lfschein.versanddatum >= ChVon
no-lock no-error.
.....
This result comes slow.ChVon greater or equal than the actual day.
When i use "today" instead of >= ChVon the result comes much faster.
But i cant use the today function, because i my query i have to over more than days.
What can i do ?
Thanks for help.
Make