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 <[email protected]>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 <[email protected]> wrote:
>
>> Hi Staffan
>>
>> On Tue, Oct 30, 2012 at 11:25 AM, hakan <[email protected]>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
>> [email protected]
>> 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
> [email protected]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/oorexx-users
