Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello QVers,
I'm trying the script:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
let
vMINDATUM=num(peek('Bestelldatum', 0,'Bestellungen'))
;
let
vMAXDATUM=num(peek('Bestelldatum', -1,'Bestellungen'))
;
DATUMSFELD:
load
date($(vMINDATUM)+iterno()-1) as DATUMSFELD
autogenerate (1)
while $(vMINDATUM)+IterNo()-1<=$(vMAXDATUM)
;
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
I always got the error:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Didn't find field - <<=>
Datumsfeld:
...
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Can anyone see what's wrong? Because the scipt is from QV-Developer course.
Thank You. I'm using QV=9.00.7440.8 SR3
dj_skbs
Hi,
your tablename "Bestellungen" is miss-spelled. It should be "BESTELLUNGEN_z". Don't forget the case sensitivity! The peek-statement returns no error if it can't find the tablename (or fieldname!). This is ugly but real.
use trace to see what is in a variable
trace varMinDatum --$(varMinDatum)--;
trace varMaxDatum --$(varMaxDatum)--;
Good luck and Enjoy QV
Roland
Hi,
vMAXDATUM is NULL ¡? please verify
good luck
/Luis.
Hi,
you can use the trace - command to see what is in your variable(s). Some seem to be null.
Regards, Roland
Hi,
yes, you all are right and I also got the info that there must be something NULL with the variable.
May be I don't see the wood for the trees, I'm racking my brains or anything else > I can't find out
the problem.
So I will send You my opus in a zip file containing qv and sources from qv-course and I want to rebuild that.
Please see attached. Thank You.
dj_skbs
Hi,
your tablename "Bestellungen" is miss-spelled. It should be "BESTELLUNGEN_z". Don't forget the case sensitivity! The peek-statement returns no error if it can't find the tablename (or fieldname!). This is ugly but real.
use trace to see what is in a variable
trace varMinDatum --$(varMinDatum)--;
trace varMaxDatum --$(varMaxDatum)--;
Good luck and Enjoy QV
Roland
Hi, that's it. Thank You Roland and the others. dj_skbs