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?
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.
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;
16 People are following this question.
© 1993- FlexSim Software Products, Inc. All Rights Reserved.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
