executeSQL

Canonical ID: data.execute.

executeSQL(sql, parameters)

Runs one SQL statement without result rows and returns the changed-row count. Bind values with positional ? parameters. Requires SQLite access.

Returns a Map with ok, status, value and error. Check ok before using value; denial or an unavailable host is a structured failure.

Requires Creator Pro or its technical trial for IDE/CLI run and build. Available on desktop, CLI and supported native exports; not in the public playground. Source remains editable in Learner. Generated apps have no Pliro licence check.

Call example

See the advanced application guide for declarations, explicit host permissions and complete examples. This call assumes the required permissions; handle means the value from a successful open operation.

executeSQL("CREATE TABLE notes (text TEXT)", [])

Built-ins