Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
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
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!