Help Center
/
Help Center›AfxNova›CSQLite Class

CSQLiteStmt.Execmethod

Convenience wrapper for **Prepare** and **Step_**.

DatabasesmethodCSQLite.incdoc-orphan
No implementation located. This member is documented, but the source scan found no matching declaration. It is likely declared in a header this scan does not resolve, or provided by a macro.

Syntax

FUNCTION Exec (BYREF wszSql AS WSTRING) AS LONG

Parameters

NameDescription
wszSqlThe SQL statement.

Return value

SQLITE_BUSY means that the database engine was unable to acquire the database locks it needs to do its job. If the statement is a COMMIT or occurs outside of an explicit transaction, then you can retry the statement. If the statement is not a COMMIT and occurs within an explicit transaction then you should rollback the transaction before continuing.

SQLITE_DONE means that the statement has finished executing successfully. Step_ should not be called again on this virtual machine without first calling Reset to reset the virtual machine back to its initial state.

SQLITE_ERROR means that a run-time error (such as a constraint violation) has occurred. Step should not be called again on the virtual machine. More information may be found by calling ErrMsg.

Description

Convenience wrapper for Prepare and Step_. To be used with queries that don't return result sets, such CREATE, UPDATE and INSERT.

Reference

  • Include file CSQLite.inc
  • Documented in Databases/CSQLite Class.md
  • Topic: CSQLite Class