Documentation

#SQLCLOSE

Added in v3.11

SQLCLOSE

Syntax: #SQLCLOSE name
Related: #SQLDB

Closes a previously opened SQL database.

SQLCLOSE examples

#SQLDB sessions.db
row = %sql(sessions, "SELECT * FROM chardb")
#WHILE (!@row.Eof()) {#SHOW @row.Item("Title");#CALL @row.Next}
#SQLCLOSE sessions

Loops through the local "sessions.db" SQLite database and displays the Title of each session.

Add comment

Login or register to post comments