Christopher Wyatt wrote: > Brian Stevens wrote: >> Robert Purves wrote: >>>> Here's a complete FBtoC program that interacts, in a limited but >>>> instructive manner, with SQLite. >>> Very nice Robert. Thanks for posting. Which docs did you consult >>> for calls? I'd like to look at this. > Just the header file: /usr/include/sqlite3.h > If things are pretty straightforward, we could create a framework > for those interested in using SQLite. Combined with SQLite Manager > or a similar tool, we'd have a nice database alternative to > REALbasic. (Since SQLite Manager is an RB app, we could work towards > replacing that, too... just a thought.) See the primitive demo <www.4toc.com/fb4/SQLite_in_FBtoC.zip> which creates a db and adds some data to it, calling the C API directly as proof-of-concept. A set of FB wrapper functions, i.e. what you call a "framework", is clearly required to make this usable. > In RB, queries are returned as a recordset, versus loading them into > an array or using pointers. What approach or mix of approaches would > work with FutureBASIC? I love FOR EACH using records, but there is a > lot to be said for arrays with small queries. I know nothing about SQL, and so can't comment further. Robert P.