Hi, how can I use OLDFIRSTOCCURENCE as an Scriptvariable?
LOADMaxString(Status.FIRSTOCCURRENCE) as OLDFIRSTOCCURRENCEFROM status.qvd (qvd);
I already tested:
let OLDFIRSTOCCURRENCE = peek('OLDFIRSTOCCURRENCE');
but it doesn't work!
best regardsIngo Placzek
the correct definition is:
Let varOLDFIRSTOCCURRENCE = peek('OLDFIRSTOCCURRENCE', 0, 'TableName');
See QV help for more details.
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 OLDFIRSTOCCURRENCEFROM statustime.qvd (qvd);
let varOLDFIRSTOCCURRENCE = peek('OLDFIRSTOCCURRENCE',0,'Statustime');
It's happening to me, and I work around that doing instead
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
please upload some sample data.
I used this kind of statement very often and it worked well.
in FIRSTOCCURRENCE are timestamps like: 2010-02-20 04:00:01.000000
how can i upload qvd files?
Go to "Reply" ==> Options ==> Add/Update
Hi, here is the qvd-file
hope your problem is solved now.
Retrieving data ...