Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Can you tell me, please, what am I doing wrong:
load
...
recno() as numstring
resident Result;
let varRowCount=2*max(numstring);
temp:
load recno() as row_counter
AutoGenerate(varRowCount);
Regards,
Alexa
You need to use the peek function in order to store the numstring into the varRowCount variable.
I am sending you your example slightly modified
TEST:
load
...
recno() as numstring
resident Result;
maxnumstring_table:
LOAD
max(numstring) AS maxnumstring
Resident TEST;
let varRowCount= 2 * peek('maxnumstring', 0, 'maxnumstring_table' );
temp:
load recno() as row_counter
AutoGenerate(varRowCount);
I hope this helps
Regards
Agis
You need to use the peek function in order to store the numstring into the varRowCount variable.
I am sending you your example slightly modified
TEST:
load
...
recno() as numstring
resident Result;
maxnumstring_table:
LOAD
max(numstring) AS maxnumstring
Resident TEST;
let varRowCount= 2 * peek('maxnumstring', 0, 'maxnumstring_table' );
temp:
load recno() as row_counter
AutoGenerate(varRowCount);
I hope this helps
Regards
Agis
Agis Kalogiannis, thanks a lot!