There's a printkeys function in the datagrid library: send "printkeys" to group "Datagrid1", same format as I think you referred to for the SQLYoga printkeys. There is a caveat that it only prints the first line of each key but that might be OK for you.
Pete Haworth On Mar 21, 2011, at 5:18 PM, Bob Sneidar wrote: > You may remember a while back my wanting a quick way to extract a single > column of data from a datagrid without having to go through a repeat loop? > Well if you use Trevor's sqlYoga, it comes with a neat little function called > printkeys(). If you have it, try this trick: > > Let's say you have a datagrid called "myDatagrid" with 3 columns, columna, > columnb, columnc. You just want columnc. > > -- get text of the array data > put the dgData of group "myDatagrid" into aArray > put printKeys(aArray) into theData -- now we have text > > -- at this point you need to know the name of your column > filter theData with "*columnc: *" -- now just the columnc lines > > -- isolate everything before the first value which is leading spaces, > -- the column name, a colon and a trailing space, the same for all lines > put word 2 of theData into theWord > put offset(theWord, theData) into firstChar > > -- now let's delete everything before the values on each line > replace char 1 to firstChar - 1 of theData with empty in theData > put theData -- this is now just the data in columnc > > It would be nice if printkeys() was public domain but I don't think it is. > Still, sqlYoga is a good investment anyways. Heck I might have paid what he > charges for sqlYoga just for that function! ;-) > > Bob > > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
