Table.query with parameters passed via $1 causes crashes in 19.2.4

Question

question

Claire Krupp asked Dec 9, '19 Claire Krupp commented Dec 11, '19

Table.query with parameters passed via $1 causes crashes in 19.2.4

I am upgrading a model from 19.1.1 to 19.2.4 which has numerous table.query calls to both Global Tables and Global Lists.

Commands with the $1 construct work fine in 19.1.1 but cause the software to completely crash on 19.2.4.

For example, here are a couple lines I put into the Script editor and ran in both versions:

string dockid = "Dock2";
int numrows = Table.query("SELECT * FROM [Dock Assignment] WHERE [DockID] = $1",dockid).numRows;

The table "Dock Assignment" looks like this:

I took out the breakpoints based on the answers to similar questions posted here, and that solves the problem, but it is going to make it very hard to test the dozens of Table.query commands in the model.

The full model is very large and proprietory so I will try to create a scaled down version to upload.

Hoping it is fixed in version 20.0.0? @phil.bobo

Software Version:

FlexSim 19.2.4

debugger table queries

dock-assignment-table.png (10.0 KiB)

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2019-12-10T17:13:53Z

anthony.johnson answered Dec 10, '19 Claire Krupp commented Dec 11, '19

This problem has been fixed in 20.0. It had to do with the FlexScript debugger.

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Claire Krupp commented · Dec 11, 2019 at 04:25 PM

Thank you! I will upgrade and check it out!

0 ·

question