Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, how can I use OLDFIRSTOCCURENCE as an Scriptvariable?
LOAD
MaxString(Status.FIRSTOCCURRENCE) as OLDFIRSTOCCURRENCE
FROM status.qvd (qvd);
I already tested:
let OLDFIRSTOCCURRENCE = peek('OLDFIRSTOCCURRENCE');
but it doesn't work!
best regards
Ingo Placzek
Hi,
the correct definition is:
Let varOLDFIRSTOCCURRENCE = peek('OLDFIRSTOCCURRENCE', 0, 'TableName');
See QV help for more details.
Good luck!
Rainer
Hi, I write it like this, but varOLDFIRSTOCCURRENCE is empty.but in an listbox, he shows me the value.
Statustime:
LOAD
MaxString(Status.FIRSTOCCURRENCE) as OLDFIRSTOCCURRENCE
FROM statustime.qvd (qvd);
let varOLDFIRSTOCCURRENCE = peek('OLDFIRSTOCCURRENCE',0,'Statustime');
Hello Ingo,
It's happening to me, and I work around that doing instead
Which version of QV are you using?FieldValue('OLDFIRSTOCCURRENCE', 1)
im workin with 9.00 SR4 too, but it dowsnt work if I write:
let varOLDFIRSTOCCURRENCE = FieldValue('OLDFIRSTOCCURRENCE', 1)
the value is <NULL> like before with peek
Hi Ingo,
please upload some sample data.
I used this kind of statement very often and it worked well.
Rainer
in FIRSTOCCURRENCE are timestamps like: 2010-02-20 04:00:01.000000
how can i upload qvd files?
Go to "Reply" ==> Options ==> Add/Update
Rainer
Hi, here is the qvd-file
Hi Ingo,
hope your problem is solved now.
Good luck!
Rainer