Staffan,
Yeah that what I meant by "OO_ARRAY_OF_ARRAYS" some wrong wording from my side,
I know
about ColumnName / columntext.
I have tried sql statements with :aname or ?1 or etc and then bind a value to
that parameter with ~bindtext as I think I get a performance gain by doing so,
part of the sql is already "compiled" by sqlite and it would be conveniant to
get the result back as directory object for each step.
As I followed the conversation about "performance observation..." I realized
that creating the directory objects with (~exec) current implementation take
some resources, I have tables with ~300 000 rows and ~10 columns, and wants to
have the convineance of using the directory objects as reference to the
returned row together with the ~bindtext possibility, less changes to some
existing code I have :-).
/hex
----- 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: lördag, 20 oktober 2012 20:45
Ämne: Re: [Oorexx-users] oosqlite ? step and result
Can a oosqlite ~step statement return the result as an OO_ARRAY_OF_DIRECTORIES
or OO_STEM_OF_STEMS or is it only possible to get result as OO_ARRAY_OF_ARRAYS ?
I have tried .oosqlite~OO_ARRAY_OF_DIRECTORIES, but still get the result as
OO_ARRAY_OF_ARRAYS
With ~exec it works OK
/hex
Håkan, not being an authority here I just want to make a guess before Mark
gives his verdict. Looking at the source code for 'step' it looks like it's
passing back the data as-is from the sqlite API, in which case you need to use
other methods to retrieve and use the data. The methods to use belong to the
column... group, such as columnText. As far as I can tell, step (should) only
return a return code. I'm sticking to 'exec' as it's more convenient.
I hope I'm not too far off target.
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
