topic Re: Trouble adding columns and rows to in-memory tables in FlexScript in FlexSim Forum

Trouble adding columns and rows to in-memory tables in FlexScript

ABarranco — Wed, 03 May 2023 09:46:14 GMT

[ FlexSim 23.1.1 ]

I’m trying to use in-memory tables in FlexScript to perform some calculations. However, I’m having trouble adding columns and rows to the tables. I don’t want to create Global Tables.

Here’s the script I’ve tried, but the return value is zero:

Table testTable;
testTable.setSize(4,4, DATATYPE_NUMBER);
return(testTable.numCols);

Can anyone help me figure out what I’m doing wrong?

Mensaje recibido. Sure! Here's a revised version of your text: I'm trying to use in-memory tables in FlexScript to perform some calculations. However, I'm having trouble adding columns and rows to the tables. I don't want to create Global Tables. Here's the script I've tried, but the return value is zero: ``` Table testTable; testTable.setSize(4,4, DATATYPE_NUMBER); return(testTable.numCols); ``` Can anyone help me figure out what I'm doing wrong?

Re: Trouble adding columns and rows to in-memory tables in FlexScript

joerg_vogel_HsH — Wed, 03 May 2023 10:38:29 GMT

Maybe you need another table operation, like adding values to cells.

Re: Trouble adding columns and rows to in-memory tables in FlexScript

ABarranco — Wed, 03 May 2023 10:52:32 GMT

Thank you for your suggestion. I tried adding values to cells, but I got an exception error: “FlexScript exception: Invalid row number: 1 in <no path> at <no path> c: <no path> i: <no path>”.

Re: Trouble adding columns and rows to in-memory tables in FlexScript

ABarranco — Wed, 03 May 2023 11:53:09 GMT

I found a solution that works, but it seems a bit unconventional. Here’s the script I used:

Array testArray;
Table testTable = testArray.as(Table);
testTable.addRow();
testTable.addCol();
return testTable.numCols;

Is there a more standard way to achieve the same result?

Re: Trouble adding columns and rows to in-memory tables in FlexScript

jason_lightfoot_adsk — Wed, 03 May 2023 12:58:58 GMT

The array approach is probably as good as any but be aware that some functions that have a table passed to them (eg. dempirical) will require a node containing the table data. In those cases you can create a temporary node and destroy it afterwards (I often create a user command called 'createtempnode' which places nodes in a new folder at 'Tools/temp' and returns a pointer to the node).

Re: Trouble adding columns and rows to in-memory tables in FlexScript

ABarranco — Wed, 03 May 2023 13:16:37 GMT

Thank you @Jason Lightfoot! I will keep your suggestion about the nodes in mind and follow your same strategy.