Re: Search in arrays

2015-12-10 Thread Bob Sneidar
Sounds like data returned from a database query. SQL Yoga returns query data in this format. What I do is I populate a datagrid with the returned array data, then I use a selectionChanged handler in the data grid script to populate whatever I want. In my case I have distinct fields named "fld" &

Re: Search in arrays

2015-12-09 Thread Mark Schonewille
Mike is right. First you put the keys of gArray into a field, then you click on a key and put the keys of gArray[the slectedText of field 1] into field 2 et cetera. Kind regards, Mark Schonewille http://economy-x-talk.com https://www.facebook.com/marksch Buy the most extensive book on the Liv

Re: Search in arrays

2015-12-09 Thread Mike Bonner
You want the subkeys of your "main group" key? put the keys of myArray[the selectedtext of field "Maingroup"] into field "subgroup" On Wed, Dec 9, 2015 at 6:11 AM, tkuyp...@telenet.be wrote: > Hi Mark, > > Either I don’t understand this, or I didn’t explain it correctly… > gArray contains app.

Re: Search in arrays

2015-12-09 Thread tkuyp...@telenet.be
Hi Mark, Either I don’t understand this, or I didn’t explain it correctly… gArray contains app. 10.000 lines of data Item 1 is a unique ID Item 2 contains the supplier Item 3 contains the main group Item 4 contains subgroup 1 Item 5 contains subgroup 2 Item 6 contains subgroup 3 Item 7 contains su

Re: Search in arrays

2015-12-09 Thread Mark Schonewille
Hi Ton, global gArray on mouseUp put gArray[the selectedText of field 1][the selectedText of field 2][the selectedText of field 3] into field 4 end mouseUp (mind line wraps) Kind regards, Mark Schonewille http://economy-x-talk.com https://www.facebook.com/marksch Buy the most extensive bo

Search in arrays

2015-12-09 Thread tkuyp...@telenet.be
Hi, I know the following should be possible, but I’m nut used in working with arrays so some help is highly appreciated… I have a field containing around 10.000 lines of tab-separated text. The first item is a unique ID, row 2 contains the main group, row 3 to 5 contain subgroups and row 6 to 1