Hallo !
I start a query over a "choose of" Trigger of a button.
Everything works fine.
When fire the trigger again, the result comes much later than before.
Here a part of my query :
Find Kunden where Kunden.k-nr = int(trim(kunde)) no-lock no-error.
if available Kunden then do :
find first xaufpos
where (xaufpos.kdnr eq Kunde)
and (xaufpos.ldat ge ChVon) no-lock no-error no-Wait.
if not available xaufpos then
message "Für diesen Zeitraum liegen keine Kunden-Daten vor !" view-as alert-box information .
else
run Value_Del.
run Value_Set.
Run P_Del.
PercDsp :Screen-Value = "".
FOR EACH xaufpos
WHERE (xaufpos.kdnr eq Kunde)
and (xaufpos.ldat ge ChVon)
and (xaufpos.ldat le ChBis)
and (geliefert eq yes)
and (xaufpos.posstat eq "7.4")
NO-LOCK.
if xaufpos.mat = 1 then do : /* Mineral */
if xaufpos.typ = 1 THEN do :
MinEin = MinEin + string(xaufpos.stk).
...
...
...
I thougt that the reason is that i use the string-function "String(xaufpos.stk) and that a data has to be transmitted to my client. But iam not shure !
Can anyone help me.
make
I start a query over a "choose of" Trigger of a button.
Everything works fine.
When fire the trigger again, the result comes much later than before.
Here a part of my query :
Find Kunden where Kunden.k-nr = int(trim(kunde)) no-lock no-error.
if available Kunden then do :
find first xaufpos
where (xaufpos.kdnr eq Kunde)
and (xaufpos.ldat ge ChVon) no-lock no-error no-Wait.
if not available xaufpos then
message "Für diesen Zeitraum liegen keine Kunden-Daten vor !" view-as alert-box information .
else
run Value_Del.
run Value_Set.
Run P_Del.
PercDsp :Screen-Value = "".
FOR EACH xaufpos
WHERE (xaufpos.kdnr eq Kunde)
and (xaufpos.ldat ge ChVon)
and (xaufpos.ldat le ChBis)
and (geliefert eq yes)
and (xaufpos.posstat eq "7.4")
NO-LOCK.
if xaufpos.mat = 1 then do : /* Mineral */
if xaufpos.typ = 1 THEN do :
MinEin = MinEin + string(xaufpos.stk).
...
...
...
I thougt that the reason is that i use the string-function "String(xaufpos.stk) and that a data has to be transmitted to my client. But iam not shure !
Can anyone help me.
make