Yeah
Look strange

a=.oosqliteconnection~new("mytest.db",,.ooSQLite~OO_STEM_OF_STEMS)
rows.=a~exec("SELECT * FROM TBL;",.TRUE)
do x = 1 to rows.0
arow. = rows.x
say arow.A arow.B
end
::requires 'ooSQLite.cls'

I get this (trace output) ( didn't test before my first answer)
4 *-* rows.=a~exec("SELECT * FROM TBL;",.TRUE)
>>> "records"
5 *-* do x = 1 to rows.0
>>> "1"
6 *-* arow. = rows.x
>>> "record"
7 *-* say arow.A arow.B
>>> "recordan ooSQLiteConnection B1"
recordan ooSQLiteConnection B1
8 *-* end
5 *-* do x = 1 to rows.0
>>> "1"
>>> "2"
6 *-* arow. = rows.x
>>> "record"
7 *-* say arow.A arow.B
>>> "recordan ooSQLiteConnection B2"
recordan ooSQLiteConnection B2



----- Ursprungligt Meddelande -----
Från: Staffan Tylen <staffan.tylen@gmail.com>
Till: <hexit34@users.sourceforge.net> , Open Object Rexx Users <oorexx-users@lists.sourceforge.net>
Kopia:
Datum: tisdag, 30 oktober 2012 19:37
Ämne: Re: [Oorexx-users] ooSQLite and OO_STEM_OF_STEMS


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


Thanks Håkan, but I get this:

2 *-* a=.oosqliteconnection~new("test.db",,.ooSQLite~OO_STEM_OF_STEMS)
>>> "an ooSQLiteConnection"
+++ Interactive trace. "Trace Off" to end debug, ENTER to Continue. +++

3 *-* rows.=a~exec("SELECT * FROM TBL;",.TRUE)
>>> "records"
say rows.0
2
say rows.1
record
w.=rows.1
say w.
record
say w.0
record0
say w.A
recordan ooSQLiteConnection
say w.B
B1

Column B looks OK but column A looks very odd, doesn't it?

Staffan