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 <miesf...@gmail.com> wrote:
> 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
>
>
------------------------------------------------------------------------------
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
