numtostring and param

Question

question

Francesco V2 asked Mar 26, '20 Regan Blackett edited Mar 26, '20

numtostring and param

Hello someone could help me with the meaning of this command:I have the code below, do you know how work the command "param" and "+numtostring"? I mean when I use the command query what happen in a practical way?

i have the table Componentes that is structured in this way:

codProducto	codComponente	Boxes
1	2	1
1	3	2
1	4	3
1	5	4
2	3	1
2	4	2
2	5	3
3	7	1
3	8	2

int codP1 = param(1);
int codP2 = param(2);
tActual = Table.query("SELECT * FROM Componentes \
		WHERE codProducto = " + numtostring(codP1, 0, 0) + " ORDER BY Box ASC");int filasAct=tActual.numRows;
tAnterior = Table.query("SELECT * FROM Componentes \
		WHERE codProducto = " + numtostring(codP2, 0, 0) + " ORDER BY Box ASC");		
int filasAnt=tAnterior.numRows;

Software Version:

FlexSim 19.0.1

numtostring

Answer 1 · 2020-03-26T15:50:18Z

Regan Blackett answered Mar 26, '20 Regan Blackett edited Mar 26, '20

param() is a function to de-reference parameters that are passed into functions. You can see them used in the code header for any code editor window to see what parameters were passed into that event, like "item" and "current". The arguments passed into param are always a value to indicate which parameter was passed in ranked order. So param(1) means the first argument passed into this function.

numtostring() is a command that converts a numeric value into it's ASCII character (string dataype). This is important for your query because a query has to be text, so numbers have to be turned into strings for them to be used in a query like this. The '+' says to concatenate the text on the right of symbol with the text on the left.

question

numtostring and param

1 Answer

Write an Answer

Things to know…

question details