Is the global variable causing the exception "Invalid SqlQuery Object "?

Question

question

A Kamphaus asked Dec 22, '16 Adrian Haws answered Dec 22, '16

Is the global variable causing the exception "Invalid SqlQuery Object "?

I am trying to query a list to get a token that does not have the same material ID as the another token. The "other" token is not the one doing the pulling so I stored the material ID for that token in a global string array so I could access it.

Why is this pull then invalid?

lbsMaterial is a label field on the list.

Software Version:

FlexSim 16.2.2

query pull from list sql list pull global variables

pull.png (29.6 KiB)

Answer 1 · 2016-12-22T22:31:07Z

Adrian Haws answered Dec 22, '16

There is not extensive Flexscript support in SQL. If you need to use a value from a global variable, you can create a label and use that in your SQL query.

question