Re: [Oorexx-users] ooSQLite and OO_STEM_OF_STEMS

[Staffan T. <sta...@gm...>]

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 <mie...@gm...> wrote:

> 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
>
>
>
> ------------------------------------------------------------------------------
> 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
> Oor...@li...
> https://lists.sourceforge.net/lists/listinfo/oorexx-users
>
>