Why debugging SQL crashes in FlexSim 2022 Update 1?

[enrique.elizaga]

[ FlexSim 22.1.1 ]

Hi, when I run the model it runs perfectly. When i debug step by step it says "no resolvable tables" and it fails.

I attach the model with a debugging tick. If the problem cannot be solved can you please convert my file to the previous version where this doesn´t happen?

Aliaxis Red V0_14.fsm

[moehlmann_fe · Accepted solution]

This is a known bug in the current version (see answer on this post).

https://answers.flexsim.com/questions/120454/error-in-tablequery-after-upgrade-to-2211.html

In my experience it only affects queries that use the $-syntax to pass in parameters. If you splice the parameters directly into the query string the error shouldn't occur.

// Example that adds the integer 4 to the query as a string
int test = 4;
Table result = Table.query("SELECT * FROM GlobalTable1 WHERE [Col 1] == " + string.fromNum(test, 0) + " ORDER BY [Col 2]");
return result.numRows;

[jason_lightfootVL7B4]

@Enrique Elizaga This should be fixed in the latest release 22.1.2 - please try that.

[kavika_faleumuE6HT5]

Hi @Enrique Elizaga, was Felix Möhlmann's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

[ckruppU5CNT]

I can confirm this problem is fixed in version 22.1.2

[jason_lightfootVL7B4]

Thanks Claire.