topic Re: Loop through resident Table in App Development

Loop through resident Table

erp_curaden — Sat, 16 Nov 2024 20:08:43 GMT

Hi everyone,

I ran into an issue where I need to loop through a dataset and update some values. But I always get an error (undefined for) if I try to use the function "NoOfRows()" in a for-loop:

TableA:
Load
*
From $(PreloadPath)Customer.qvd](qvd);

ResultTable:
Load * Inline [
'A', 'B', 'C'
];

TableB:
For $i=1 to NoOfRows(TableA)
Concatenate(ResultTable)
Load * Inline [
'A', 'B', 'C'
'X', 'X', 'X'
];
Next;

If someone has an idea what I'm doing wrong, please reply 🙂

Re: Loop through resident Table

tresB — Wed, 04 Sep 2019 12:25:23 GMT

Missing quotes around table name. Try like: NoOfRows('TableA')

Re: Loop through resident Table

Vegar — Wed, 04 Sep 2019 12:27:40 GMT

You should not use NoOfRows(TableA) in this case but NoOfRows('TableA') .

TableA: Load * From $(PreloadPath)Customer.qvd](qvd); ResultTable: Load * Inline [ 'A', 'B', 'C' ]; TableB: For $i=1 to NoOfRows('TableA') Concatenate(ResultTable) Load * Inline [ 'A', 'B', 'C' 'X', 'X', 'X' ]; Next;

Read more on the function: NoOfRows - script and chart function

Re: Loop through resident Table

erp_curaden — Wed, 04 Sep 2019 12:29:15 GMT

Great, thank you 🙂