question

IT Asset avatar image
0 Likes"
IT Asset asked Adrian Haws answered

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.

FlexSim 16.2.2
querypull from listsqllist pullglobal variables
pull.png (29.6 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

Adrian Haws avatar image
2 Likes"
Adrian Haws answered

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.

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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