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

Reply via email to