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

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

ITAsset
Not applicable
19 Views
1 Reply
Message 1 of 2

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

ITAsset
Not applicable

[ FlexSim 16.2.2 ]

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?

4383-pull.png

lbsMaterial is a label field on the list.

0 Likes
Accepted solutions (1)
20 Views
1 Reply
Reply (1)
Message 2 of 2

adrian_haws
Not applicable
Accepted solution

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.