Home Contents | # sql:finish | Sql | Core4 Lua Commands

## SYNOPSIS

query:finish()

## DESCRIPTION

Instructs the database code that last statement will no longer be needed.

This is automatic on garbage collection and whenever a new statement is prepared on the query handle.

Since garbage collection happens at an unknown time, it is good practice to finish a query in that manner when done with it. Failing to finish a query may cause the database to stay locked.

## SEE ALSO

sql:prepare, sql:bind, sql:exec, sql:next, sql:value, sql:reset