sqlite_exec

mIRC SQLite

sqlite_exec
Executes a result-less SQL query.
Syntax
$sqlite_exec ( conn, query [, bind_value [, ... ] ] ) [ .file ]
/sqlite_exec conn query
$sqlite_exec ( statement [, bind_value [, ... ] ] )
/sqlite_exec statement [ bind_value [ ... ] ]
Parameters
conn
The connection identifier.
query
The query to execute.
statement
A prepared statement to execute.
bind_value
Optional. One or more values to bind to the query.
Properties
file
Optional. If specified the query parameter is treated as a filename instead, and that file will be executed as SQL.
Return Value
1 on success, or $null if there was an error.
Remarks
To execute a prepared statement, first prepare it with $sqlite_prepare.
To learn about prepared statements and binding values, see Prepared Statements.

If $null is returned you can determine the exact reason for the error by checking the value of %sqlite_errstr.
For more information about error handling, see Handling Errors

Note that if you want to bind a text value with more than one word, you must use the identifier form of syntax. If you don't care about the return value, you can use the built-in mIRC command /noop

Starting from mSQLite version 1.2.0 you can bind values even for non-prepared statements, but this only works when calling $sqlite_exec as an identifier.

$sqlite_exec can execute multiple queries seperated by semicolons.
To see guidelines for writing SQL queries with mIRC SQLite, see Writing Queries.
Example
; Inserts data to a table, assumes that a db connection is already established
var %sql = INSERT INTO table (key, value) VALUES ('version', '1.0.0')
if ($sqlite_exec(%db, %sql)) {
  echo -a Query executed succesfully.
}
else {
  echo -a Error executing query: %sqlite_errstr
}