Hi there,
i want to compare two dates in a query:
(lajo.dat >= Zeitraum_von)
(lajo.dat <= Zeitraum_bis)
if Buchungsart = 2 then do:
OPEN QUERY {&SELF-NAME} FOR EACH lajo, each xaufpos
WHERE (xaufpos.aarnr = int(lajo.belegnr))
and (lajo.dat >= Zeitraum_von)
and (lajo.dat <= Zeitraum_bis) no-lock,
first homa.lieferer where lieferer.k-nr = int(substring(xaufpos.artikel_nr,1,2))
NO-LOCK.
end.
But it doesnt work !
Did i make a mistake ?
When i start the browser , he hangs up !
Greets
make
i want to compare two dates in a query:
(lajo.dat >= Zeitraum_von)
(lajo.dat <= Zeitraum_bis)
if Buchungsart = 2 then do:
OPEN QUERY {&SELF-NAME} FOR EACH lajo, each xaufpos
WHERE (xaufpos.aarnr = int(lajo.belegnr))
and (lajo.dat >= Zeitraum_von)
and (lajo.dat <= Zeitraum_bis) no-lock,
first homa.lieferer where lieferer.k-nr = int(substring(xaufpos.artikel_nr,1,2))
NO-LOCK.
end.
But it doesnt work !
Did i make a mistake ?
When i start the browser , he hangs up !
Greets
make