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?
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.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
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.
May we collect and use your data?
Learn more about the Third Party Services we use and our Privacy Statement. May we collect and use your data to tailor your experience?
Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.
