SQL table query exception when included in a user command (only 19.2)

[david_besson]

[ FlexSim 19.2.0 ]

The behaviour of my table query depends from where I execute it:

• through the script console -> it behaves as expected
• through a user command -> it throws an exception

Did I do something wrong? Please notice it worked with the previous version 19.1.2.
Could it be related also to this post?

Thanks!

sql-exception-query-in-command.fsm

[philboboADSK · Accepted solution]

It is related to this post: SQL Query Error - Flexsim 19.2

The issue is not Script vs User Command. The issue is whether you have breakpoints in the code.

If you have breakpoints in a FlexScript function or you have the debug() command anywhere within a FlexScript function, then the FlexScript compiler does not compile the entire function at once. Instead, it compiles and executes one line at a time so that you can debug it.

Something in our changes to the table query commands in 19.2.0 broke this one-line-at-a-time execution of table queries. We've added a case to the dev list to fix this.