DbExec

dbExec

Executes a prepared SQL statement when no row result is required.

Syntax

bool dbExec(DatabaseConnection connection, string statement, ...)

Parameters

Name	Type	Required	Description
connection	DatabaseConnection	yes	The connection used to execute the statement.
statement	string	yes	SQL containing ? value placeholders.
...	nil/bool/number/string	no	Values bound to the placeholders.

Returns

Returns true when the statement is queued successfully; otherwise returns false.

Examples

Update a player's level safely:

local ok = dbExec(db,
    "UPDATE players SET level = ? WHERE id = ?",
    newLevel,
    playerId
)

if not ok then
    outputDebugString("Could not queue level update", 1)
end

Notes

• Available only in server-side resource scripts.
• Use placeholders instead of concatenating untrusted values into SQL.