Why debugging SQL crashes in FlexSim 2022 Update 1?

enrique.elizaga
Advocate Advocate
0 Views
5 Replies
Message 1 of 6

Why debugging SQL crashes in FlexSim 2022 Update 1?

enrique.elizaga
Advocate
Advocate

[ 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

0 Likes
Accepted solutions (1)
1 View
5 Replies
Replies (5)
Message 2 of 6

moehlmann_fe
New Member
New Member
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;
0 Likes
Message 3 of 6

jason_lightfootVL7B4
Autodesk
Autodesk
@Enrique Elizaga This should be fixed in the latest release 22.1.2 - please try that.
Message 4 of 6

kavika_faleumuE6HT5
Autodesk
Autodesk

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.

0 Likes
Message 5 of 6

ckruppU5CNT
Not applicable

I can confirm this problem is fixed in version 22.1.2

Message 6 of 6

jason_lightfootVL7B4
Autodesk
Autodesk
Thanks Claire.
0 Likes