https://forums.autodesk.com/t5/flexsim-forum/is-the-global-variable-causing-the-exception-quot-invalid/m-p/13559738#M62461 <P>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.</P> Thu, 22 Dec 2016 22:31:07 GMT adrian_haws 2016-12-22T22:31:07Z https://forums.autodesk.com/t5/flexsim-forum/is-the-global-variable-causing-the-exception-quot-invalid/m-p/13559737#M62460 <P><I>[ FlexSim 16.2.2 ]</I></P><P>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.</P> <P>Why is this pull then invalid?</P> <P><span class="lia-inline-image-display-wrapper" image-alt="4383-pull.png"><img src="https://forums.autodesk.com/t5/image/serverpage/image-id/1494708i2ED80FBE5E791FCC/image-size/large?v=v2&amp;px=999" role="button" title="4383-pull.png" alt="4383-pull.png" /></span></P> <P>lbsMaterial is a label field on the list.</P> Thu, 22 Dec 2016 20:25:18 GMT https://forums.autodesk.com/t5/flexsim-forum/is-the-global-variable-causing-the-exception-quot-invalid/m-p/13559737#M62460 itassetV4AHC 2016-12-22T20:25:18Z https://forums.autodesk.com/t5/flexsim-forum/is-the-global-variable-causing-the-exception-quot-invalid/m-p/13559738#M62461 <P>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.</P> Thu, 22 Dec 2016 22:31:07 GMT https://forums.autodesk.com/t5/flexsim-forum/is-the-global-variable-causing-the-exception-quot-invalid/m-p/13559738#M62461 adrian_haws 2016-12-22T22:31:07Z