ATTENTIONThis FlexSim Community Forum is read-only. Please post any new questions, ideas, or discussions to our new community (we call it Answers) at https://answers.flexsim.com/. Our new Question & Answer site brings a modern, mobile-friendly interface and more focus on getting answers quickly. There are a few differences between how our new Q&A community works vs. a classic, threaded-conversation-style forum like the one below, so be sure to read our Answers Best Practices. |
flexsim.com |
#1
|
|||
|
|||
Can SQL be used in array data?
There are some new fetures about array since v7.7:
1.Arrays (int, double, string and treenode) can be stored on nodes such as labels. 2.Arrays are now viewable/editable as tables. 3.Made the sql IN clause work if you compare it against a value that is an array. Help: How can I store an array on a node ? how can I edit an array as table? What\'s the exact meaning of "compare it against a value that is an array" about SQL in clause? Is there any example? Thanks so much ~~ |
#2
|
||||
|
||||
These features were mostly added to accommodate process flow needs, so command-wise, right now setlabel() is the only command that will set a node's value to an array (we hope to extend that in the future).
The attached model has an example that uses arrays. It sets a label named "array" on the tokens on the left. You can click on the tokens, then in Quick Properties, right-click on a label and choose Explore as Table to edit the array values. The attached model also uses the SQL IN clause, where tokens on the right try to get a token on the left that has a specific target value in its array. |
The Following 6 Users Say Thank You to Anthony Johnson For This Useful Post: | ||
Steven Hamoen (04-22-2016) |
#5
|
||||
|
||||
Bundle data is stored in memory. You can give a node bundle data and add, remove, and set values in the bundle. That's all in memory.
If you are talking about having a purely locally defined "bundle", i.e. a two-dimensional array local to a flexscript function, unfortunately flexscript doesn't support two-dimensional arrays at this point, although that is on our development radar. |
The Following 4 Users Say Thank You to Anthony Johnson For This Useful Post: | ||
Steven Hamoen (04-22-2016) |
#6
|
|||
|
|||
Quote:
Waiting for the new feture~~ |
Tags |
array, sql, table |
Thread | Thread Starter | Forum | Replies | Last Post |
How to pick more than one value from an array? | mearjun | Q&A | 1 | 07-20-2014 12:57 AM |
Array of Itemtypes - few problems | daniel dunst | Q&A | 1 | 06-05-2012 10:30 AM |
Maximum Value inside an array | Congshi Wang | Q&A | 4 | 03-02-2011 10:53 AM |
array size | juan alberto | Q&A | 0 | 12-21-2010 03:03 AM |
Can't get value from global array | Joe Allen | Q&A | 7 | 10-30-2008 09:06 AM |