Es sql close

From EventScripts Community Encyclopedia

es_sql close is the correct title for this article. The title you see above is incorrect due to technical limitations.

Overview

Syntax: es_sql close <db-name>

Note: Command parameters are described inside the < and > characters. Optional parameters are contained within [ and ] characters.

Variation of this command that doesn't expand variables: es_xsql close

Closes and flushes the database data to disk.

See the ServerMail example in ES v1.5 for a detailed example.

// open a SQLite database file
es_sql open mydb |myscriptdir
// other es_sql query commands
// ...
es_sql close mydb