Issue in assigning values to variables

[#1]

Good Evening,

I have a stragne issue, in the below I am Loading the maximum value of Euro and storing in Lmax variable and I can see the value in using text object.

But when I assign the Lmax to MEuro it shows the null value.

What is the issue in it.

Leasd:
     Load Max(Euro) as Lmax    
     FROM c:\test\QVFW.QVD (qvd) ;

    
     Let MEuro=Lmax

 
map1

mapping load 
[Euro],[Invoice Number]
FROM c:\test\QVFW.QVD (qvd) ;

let MaxInv=ApplyMap ( 'map1', Lmax )

Regards

Joe

[#2]

Hi

Test to do it in a couple of steps - load everything you need from .qvd beforehand without any transformation and then use e.g. Max and Mapping Load resident...

/@Ungvall

[pat_agen · Accepted solution]

Hi,

Lmax is a field in the table Leasd. Try this to give the value to Meuro:

LET MEuro=peek('Lmax',-1,Leasd);

if LET doesn't work try SET!