copied to User_RS in the calling program *User_RS = PtrUserRS make parameter global RS (=Recordset) structured variable is ProcedureDLL.l SQ3_4_LB_GetRecordset(sSQLQuery.s, lDBhnd.l,PtrUserRS.l) get results of a SELECT query in a recordset HResult = CallCFunctionFast(sqlite3_exec, lDBhnd, sSQLQuery, #Null, #Null, hResult = #SQLITE3_OK ProcedureDLL.l SQ3_4_LB_Execute(sSQLQuery.s, lDBhnd.l) execute SQL commands (Insert,Update,Delete) HResult = CallCFunctionFast(sqlite3_close, lDBhnd) ProcedureDLL.l SQ3_4_LB_CloseDB(lDBhnd.l) close a database LastMessage$ = "There already exists a file named '" + sDataBase + "'" LastMessage$ = "Couldn't delete '" + sDataBase + "'" LastMessage$ = "Couldn't create database" If FileSize(sDataBase) = -1 DB does not exist ProcedureDLL.l SQ3_4_LB_CreateDB(sDataBase.s, bolOverwrite.l) create a new database HResult = CallCFunctionFast(sqlite3_open, sDataBase, hResult = #SQLITE3_OKĪddElement(OpenFiles()) : OpenFiles() = sqlite3_dbHandleĬallCFunctionFast(sqlite3_errmsg, = PeekS(ReturnValue) > SQ3_4_LB.dll is released 'as is' in the hope that it will be useful, > but WITHOUT ANY WARRANTY without even the implied warranty of > MERCHANTABILITY Or FITNESS For A PARTICULAR PURPOSE. The same license applies to SQ3_4_LB.dll.
PBOSL is distributed under the terms of the GNU Lesser General Public License. SQLite3 Userlibrary V1.1 () by Peter 'Kiffi' Tübben.
This code is based on the PureBasic OpenSource Libraries (PBOSL)
It has only the basic functions implemented, there is no support for blobs or unicode. SQ3_4_LB.dll is a wrapper for sqlite3.dll to be used with Liberty Basic.