From: Mark M. <mie...@gm...> - 2012-10-30 18:54:54
|
Hi Staffan On Tue, Oct 30, 2012 at 11:25 AM, hakan <he...@us...>wrote: > ** > > > rows.=a~exec("SELECT * FROM TBL;",.TRUE) > > do x = 1 to rows.0 > arow. = rows.x > say arow.A arow.B > end > should do it,If I recall it correct > Look at Marks sample execTestS.rex in oosqlite directory testing > This is pretty much the reply I would have given, thanks /hex. Just a few comments to maybe clarify a few things. The stem returned has the number of rows in stem.0. Say stem.0 == n. Then stem.1 ... stem.n contain a stem for each row. For that stem, there is an index for each column in the row. The index name is the upper case version of the column name and the value at that index is the value of the column in that row. I know I'm a little lagging on the documentation for ooSQLite, but this is explained in the doc, and there is an example as /hex pointed out. ;-) -- Mark Miesfeld |