sqlite_exec_file

mIRC SQLite

previous page next page
sqlite_exec_file
Executes a result-less SQL query from a file.
Syntax
$sqlite_exec_file ( conn, file [, bind_value [, ... ] ] )
/sqlite_exec_file conn file
Parameters
conn
The connection identifier.
file
The file to execute.
bind_value
Optional. One or more values to bind to the query.
Return Value
1 on success, or $null if there was an error.
Remarks
This is an alias for $sqlite_exec(...).file

This command is useful for executing a long query or multiple queries.
One common use is executing an initialization query file after loading a script.
Example
; A possible LOAD event for a script
on *:LOAD:{
  var %db = $sqlite_open(script.db)
  sqlite_exec_file %db init.sql
  sqlite_close %db
}
previous page start next page