How to use/create a Scriptvariable via LOAD

[#1]

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

[#2]

Hi,

the correct definition is:

Let varOLDFIRSTOCCURRENCE = peek('OLDFIRSTOCCURRENCE', 0, 'TableName');

See QV help for more details.

Good luck!

Rainer

[#3]

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');

[Miguel_Angel_Baeyens]

Hello Ingo,

It's happening to me, and I work around that doing instead

FieldValue('OLDFIRSTOCCURRENCE', 1)

Which version of QV are you using?

[#5]

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

[#6]

Hi Ingo,

please upload some sample data.

I used this kind of statement very often and it worked well.

Rainer

[#7]

in FIRSTOCCURRENCE are timestamps like: 2010-02-20 04:00:01.000000

how can i upload qvd files?

[#8]

Go to "Reply" ==> Options ==> Add/Update

Rainer

[#9]

Hi, here is the qvd-file

[#10]

Hi Ingo,

hope your problem is solved now.

Good luck!

Rainer