Didn't find field...

[#1]

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

[llauses243]

Hi,

vMAXDATUM is NULL ¡? please verify

good luck

/Luis.

[#3]

Hi,

you can use the trace - command to see what is in your variable(s). Some seem to be null.

Regards, Roland

[#4]

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

[#5 · Accepted solution]

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

[#6]

Hi, that's it. Thank You Roland and the others. dj_skbs