Can't get data from a Data Grid

[bogs]

Someone please remind us both where the "alternate" dictionary is. I am not at my normal computer, and do not have the URL here.

Assuming you didn't mean Tiny Dictionary (which Klaus helpfully linked too, and is the quickest I know of), I'm thinking you might be looking for Milby's online one here, or alternately, Max's excellent wiki version here which is super-duper quick and includes not only the examples found in the dictionary, but personal examples like the old comments section used to hold.

I was being frustrated. When I'm pointed to an article as though it answers my question, when it doesn't in fact answer my question, then I'm afraid I can't see that as helpful.

I can understand frustration, and I'm sorry if you feel I contributed to yours, however, I wasn't pointing to that article "as though it answers my (your) question", I was in fact asking if that held what you were asking about for clarity, which is why there is a question mark at the end of the sentence and before the link.

Hmmmmm.... you mean this?

Although that section talks about behavior scripts, I am pretty sure the sections referred to *are* in fact the way you'd go after the information. However, I am no DG expert, and certainly defer to others when my own assumptions are incorrect. In this case, I was looking for clarity into what exactly you were trying to get to. I'm glad Klaus could answer it for you.

[Klaus]

Although that section talks about behavior scripts, I am pretty sure the sections referred to *are* in fact the way you'd go after the information. However, I am no DG expert, and certainly defer to others when my own assumptions are incorrect.

That lesson unfortunately only deals with getting the content of one specific column.
As I said this functionality is not supplied by the datagridlibrary, but could easily be added.

[bogs]

That lesson unfortunately only deals with getting the content of one specific column.

So it wouldn't be possible to loop through to split each column out to its own array, one at a time? I'll tinker while waiting heh.

[Klaus]

That lesson unfortunately only deals with getting the content of one specific column.

So it wouldn't be possible to loop through to split each column out to its own array, one at a time? I'll tinker while waiting heh.

https://forums.livecode.com/viewtopic.p ... 81#p183963

[bogs]

LOL! DOH

[SparkOut]

If you want to sum a column to get the aggregate value, it's not one line but pretty lean:
http://lessons.livecode.com/m/datagrid/ ... or-columns

[Klaus]

Hi Sparkout,

ah, yes, or this way.

@Michael
Here a little script that you can put into your datagrid group directly (NOT the behaviour, just the script of that group):

Code: Select all

getprop dgDataOfColumns [tUserSelectedColumns]
   put the dgdata of me into sDataArray
   ## We build an CR delimited list of all entries in your columns
   repeat for each key tKey in sDataArray
      put sDataArray[tKey][tUserSelectedColumns] & CR after tTempColumns
   end repeat
   delete char -1 of tTempColumns
   return tTempColumns
end dgDataOfColumns

Then use it like this in your other scripts:

Code: Select all

...
put the dgDataOfColumns["name of your desired column here..."] of grp "ledger" into fld "display of all my beloved colums as CR delimited text"
## :-)
...

Best

Klaus

P.S.
As we can see, if LC might lack of some functionality, we add this in most cases, as long as no engine changes are required.
We can script almost everything, love it!

[MichaelBluejay]

bogs, I'm sorry I misunderstood you.

Thank you everyone for your help. I would be literally unable to complete my development without the awesome help available on this forum.

[bogs]

's no problem

People are hard enough to understand most times, even in person where you have visual clues and inflections of voice to aid in determining what they mean, in text it is always a lot harder and as I have mentioned in other posts, I know my style of writing is not possibly the best around for clarity

[jacque]

I don't suppose there's a command to get all the data for a particular column (all the rows), as either a list or an array? I looked but couldn't find one.

I know I can do the dgtext of grp "nameOfTheDataGrid" to get the whole table of data and then loop through it, but the LiveCode company goes on and on about how LiveCode requires less code than other languages, so I'd like less code here, please.

You can get the dgtext, then split it by column. Each key of the resulting array is the content of a column.

[Zryip TheSlug]

Hi Michael,

Note the DataGrid Helper plugin is capable of applying various Grand Total functions to a DataGrid

http://lessons.livecode.com/m/4068/l/85 ... l-function