topic Re: Problem with Table query using an alias in 2022 Update 1 in FlexSim Forum

Problem with Table query using an alias in 2022 Update 1

BGaskins8Y6PT — Tue, 03 May 2022 12:10:31 GMT

[ FlexSim 22.1.1 ]

The following works well in version 2022 but fails in 2022 Update 1:

int aisleNumber = 1;

Table queryTable = Table.query("SELECT * FROM RackNodes WHERE [Aisle #] == $1", aisleNumber);

The following error is reported when the query is executed:

exception: SqlQuery - Unknown error in: SELECT * FROM RackNodes WHERE [Aisle #] == $1

Did something change in 2022 Update 1 with respect to table queries? I did not find anything in the release notes.

Thanks!

Re: Problem with Table query using an alias in 2022 Update 1

jason_lightfoot_adsk — Tue, 03 May 2022 12:22:49 GMT

TestTableQueryAlias_v22.0.fsm

This quick test model suggests it's still working in 22.1.1.

Are you able to upload your model for us to take a look? If needed you can change this question and mark it private so only FlexSim support can see it.

Re: Problem with Table query using an alias in 2022 Update 1

BGaskins8Y6PT — Tue, 03 May 2022 12:37:32 GMT

The error does not occur when I run the FlexScript code from the script console but does when included in a custom code activity. Model is attached.

TableQueryTest.fsm

Re: Problem with Table query using an alias in 2022 Update 1

jason_lightfoot_adsk — Tue, 03 May 2022 13:44:59 GMT

Thanks for the test model, but I don't get an error with that model in 22.1 either - it correctly reads the values from the table. Are you using 22.1.1?

Re: Problem with Table query using an alias in 2022 Update 1

jason_lightfoot_adsk — Tue, 03 May 2022 13:48:43 GMT

Okay - it errors if you add a breakpoint to the code.

I think this is a known bug and has been reported before. We'll make a note and this case too when it's fixed. Thanks for pointing it out.