FUNCTIONS: ---------- DB_OPEN("dbname") Opens database, if succeeds it returns a handle to database, else returns DB statuscode. DB_SQL(db_handle, "sql string") Executes SQL command, returns DB statuscode (1 = OK, 0 = NOK). The SQL results stored in DB_RESULT$, SQL error messages stored in DB_ERROR$ DB_QUERY(db_handle, "sql string", callback) Executes SQL command, returns DB statuscode (1 = OK, 0 = NOK). The SQL results are passed to user defined function callback(), SQL error messages stored in DB_ERROR$ DB_CLOSE(db) Closes database, returns DB statuscode DB_STATUS$(db) If a returned DB status code is higher than 0, this function returns the status in human readable format VARIABLES: ---------- DB_FS$ Field Separator for the results in DB_RESULT$, defaults to tab, can be set to any other string by user DB_RS$ Record Separator for the results in DB_RESULT$, defaults to newline, can be set to any other string by user DB_RESULT$ Contains last result of SQL command executed by 'DB_SQL' DB_ERROR$ Contains last error string of SQL command executed by 'DB_SQL' DB_VERSION$ Returns version string of SQLite ------------- SQLITE SQL syntax here: http://www.sqlite.org/lang.html