See my next post.  The posts seem to be crossing in the ethernet.

--
Mark Miesfeld

On Tue, Oct 30, 2012 at 11:59 AM, Staffan Tylen <staffan.tylen@gmail.com> wrote:
Thanks Mark, yes /hex expalined this and it seems to work for column B in my test but not for the first column (A), there I get the strange recordan ooSQLiteConnection

Staffan


On Tue, Oct 30, 2012 at 7:54 PM, Mark Miesfeld <miesfeld@gmail.com> wrote:
Hi Staffan

On Tue, Oct 30, 2012 at 11:25 AM, hakan <hexit34@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



------------------------------------------------------------------------------
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