Thanks, Mark. I will download and start work with it this afternoon. As it happens, I have use for such a thing through ooRexx (the oo part) right now. I will let the list know.
BTW, huge thanks and congrats for your hard work and forward thinking. We all benefit from it. -----Original Message----- From: Mark Miesfeld [mailto:[email protected]] Sent: Monday, June 04, 2012 08:52 To: Open Object Rexx Developer Mailing List Subject: Re: [Oorexx-devel] Some comments on the ooSQLLite extension On Mon, Jun 4, 2012 at 6:34 AM, Dan Carter <[email protected]> wrote: > Mark, if you wish to release some sandbox versions of ooSQLite I will > certainly exercise them, although I might not be able to build them. There is a sandbox, I'm calling it a 'preview,' version on SourceForge to make it easy for people to download and join in the discussion(s). It is already built. The release notes tell you how to set it up. There is little to no documentation yet, and few examples. https://sourceforge.net/projects/oorexx/files/ooSQLite/ Read through the ReleaseNotes that displays on the SourceForge page. Even though the doc for ooSQLite is minimum at this poing, if you look at the classes and methods in ooSQLite.cls and read the SQLite doc starting at this page: http://www.sqlite.org/c3ref/funclist.html it shouldn't be too hard to play with. Especially if you have already done something with SQLite. In addition, in the ooSQLite directory there is an excel spreadsheet that lists every SQLite C API and notes whether it is implemented in ooSQLite or not. So, SQLite has the API: sqlite3_data_count which uses a sqlite3_stmt. The spreadsheet notes that API is implemented. If you are using the OO interface in ooSQLite and look at the methods of the ooSQLiteStmt class you will see the dataCount() method. That method does what the SQLite doc for the sqlite3_data_count API says it does. In a similar fashion. If you look at the ooSQLite class: ooSQLiteStmt class and see it has a method: bindText() if you look at the SQLite doc, look for sqlite_bind_text and you will have the documentation for the bindText() method. If instead you want to use the functional interface: the routine in ooSQLite: oosqlDataCount() would correspond to sqlite3_data_count the routine in ooSQLite: oosqlBindText() would correspond to sqlite3_bind_text > It seems to me that a rexx-ish > solution would be to use a stem to return queries, whether single rows > or cursors. Again, I'm not arguing that an array of arrays is the best solution. I'm saying it wouldn't be hard to let the user of ooSQLite pick the format of a result set they wanted to use. -- 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/ _______________________________________________ Oorexx-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/oorexx-devel ------------------------------------------------------------------------------ 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
