Hi Staffan

On Tue, Oct 30, 2012 at 11:25 AM, hakan <hexi...@users.sourceforge.net>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
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_sfd2d_oct
_______________________________________________
Oorexx-users mailing list
Oorexx-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/oorexx-users

Reply via email to