Mark, lets assume your table structure is something like: firstname lastname address city state zip
Now lets assume your sql query was simply: select * from table Both your and Jon's query would work fine UNTIL the point where it's determined that we now need a middleinitial column between firstname and lastname. The beauty of SQL is that column can be inserted and the integrity of the data is not harmed. HOWEVER, if your case of using an array of arrays, every statement in every script that expected the lastname to be the 2nd column to be returned would have to now be changed to the 3rd column. But, hey, what do I know. Lee On 6/3/2012 11:24 PM, Mark Miesfeld wrote: > On Sun, Jun 3, 2012 at 2:33 PM, Sahananda (Jon) Wolfers > <[email protected] > <mailto:[email protected]>> wrote: > > I know that you're thinking about the lower level now, but consider an > array of directories as > then one can refer to columns by name. I know there are some interfaces > (like windows ADODBC, > and I seem to recall JDBC was a bit like this) where you have to work > really hard to fetch each > row, and then you have to work really hard to fetch each field from the > row. It feels a whole > lot more rexxish to me to be able to say > > osql~exec(myQuery) > > do row over osql~rows > if row['name'] = 'Smith' then do ... end > end > > Well, I think the above is close to what I have now: > results = osql~exec(myQuery) > do row over results > if row[2] = 'Smith' then do ... end > end > What I was saying was that it wouldn't be too hard at this point to let the > user specify if the > returned result set was an array of arrays or an array of directory objects. > -- > Mark Miesfeld > > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > > > __________ Information from ESET NOD32 Antivirus, version of virus signature > database 7192 (20120603) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > > > _______________________________________________ > Oorexx-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/oorexx-devel > > > > __________ Information from ESET NOD32 Antivirus, version of virus signature > database 7192 (20120603) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Oorexx-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/oorexx-devel
