I'm trying for the first time to use the OO_STEM_OF_STEMS option but can't
figure out how to use or access the result. Here are two different attempts:
Using a stem variable as output:
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
say rows.2
record
say rows.1.0
records1.0
say rows.1.1
records1.1
say rows.1[1]
record1
say rows.1[2]
record2
say rows.1[2][1]
+++ Interactive trace. Error 97: Object method not found
+++ Interactive trace. Error 97.1: Object "record2" does not understand
message "[]"
say rows.1[2][a]
+++ Interactive trace. Error 97: Object method not found
+++ Interactive trace. Error 97.1: Object "record2" does not understand
message "[]"
say rows.1[a]
recordan ooSQLiteConnection
say rows.1[b]
B1
say rows.1[c]
recordC
say rows.1[d]
recordD
Using a normal variable as output:
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
records
say rows.0
ROWS.0
say rows.1
ROWS.1
say rows[1]
record
say rows[0]
2
say rows[1][1]
record1
say rows[1][a]
recordan ooSQLiteConnection
say rows[1][b]
B1
say rows[1][c]
recordC
None of the above makes sense to me. The table TBL was created like this:
CREATE TABLE TBL (A,B);
INSERT INTO "TBL" VALUES('A1','B1');
INSERT INTO "TBL" VALUES('A2','B2');
I can feel the answer is obvious, I just can't see 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
