Scripting/Squirrel/Functions/QuerySQL

This function will send a query to the database.

Syntax

QuerySQL(database, queryString);

Arguments

• SQLiteDB database - The database to query
• string queryString - The SQL query to send

Example

function onScriptLoad() {
  db <- ConnectSQL("scripts/keybinds.db");
  if (!db) {
    print("ERROR: SQLite database file could not be opened");
  }
  QuerySQL(db, "CREATE TABLE IF NOT EXISTS players(name TEXT, password TEXT, " +
           "level INTEGER, PRIMARY KEY(name,password));");
}

Notes

Calls onScriptLoad, ConnectSQL and print were used in this example. More info about them in the corresponding pages.

Related Functions

• ConnectSQL
• DisconnectSQL
• escapeSQLString
• FreeSQLQuery
• GetSQLColumnCount
• GetSQLColumnData
• GetSQLNextRow
• QuerySQL