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.ty...@gmail.com>
Till:<hexi...@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------------------------------------------------------------------------------
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
