Retrieve the SQLite Version

· Oct 18, 11:28 AM

It is sometimes useful to be able to retrieve the version of the SQLite database engine used by REALbasic. Thanks to Russ Tyndall, I now know how to get it. Here is a handy little function that returns the version.

Shared Function SQLiteVersion() As String static theVersion as String if theVersion = "" then dim db as new REALSQLDatabase if db.Connect then dim rs as RecordSet = db.SQLSelect("SELECT sqlite_version()") if rs <> nil then theVersion = rs.idxField(1).stringValue end if end if end if return theVersion End Function

---

Comment

Textile Help