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

Question

question

ABarranco asked May 3, '23 ABarranco commented May 3, '23

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

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?

Software Version:

FlexSim 23.1.1

flexscript tables

· 3

Joerg Vogel commented · May 03, 2023 at 10:38 AM

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

0 ·

ABarranco Joerg Vogel commented · May 03, 2023 at 10:52 AM

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>”.

0 ·

ABarranco commented · May 03, 2023 at 11:53 AM

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?

0 ·

Answer 1 · 2023-05-03T12:58:58Z

Jason Lightfoot answered May 3, '23 ABarranco commented May 3, '23

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).

· 1

ABarranco commented · May 03, 2023 at 01:16 PM

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

0 ·

question