How to insert the data retrieved from Query into a Container

(0) Share

Report

Posted on by Mohammed Altaf

435

Hi there,

i am trying to retrieve all the ItemIds from InventTable and want to store in an container, when the values are stored in the container,when i am trying to see the length of container its showing length = 1.

Can you please help me how to insert the data into container followed by comma (,) after each item id.

here is the code which i am using

InventTable invTable;

container conItemID;
str readitmIds;
int conLength , cnt;
while select ItemId from invTable
{
conItemID = [invTable.ItemId];
}

conLength = conLen(conItemID);
info(strFmt("Container Length %1", conLength));

}

*This post is locked for comments

All responses (2)

Answers (0)

Martin Dráb 233,326 Most Valuable Professional on at

Like (0)

Report

RE: How to insert the data retrieved from Query into a Container

Your code is overwriting conItemID every time.

Another solution is using conIns() function, but += is faster.

Note that the result is indeed a container, not a string with comma-separated values.
Mohammed Altaf 435 on at

Like (1)

Report

RE: How to insert the data retrieved from Query into a Container

Thanks @Crispin John Augustine.

You just made my day.