# sqlite3

- Manual
- Standard library
- Index

Search:
Group by:

# Types

    PSqlite3 = ptr Sqlite3

  Source Edit

    PPSqlite3 = ptr PSqlite3

  Source Edit

    Pcontext = ptr Context

  Source Edit

    PStmt = ptr TStmt

  Source Edit

    PValue = ptr Value

  Source Edit

    PValueArg = array[0 .. 127, PValue]

  Source Edit

    Callback = proc (para1: pointer; para2: int32; para3, para4: cstringArray): int32 {...}{.cdecl.}

  Source Edit

    Tbind_destructor_func = proc (para1: pointer) {...}{.cdecl, locks: 0, tags: [], gcsafe.}

  Source Edit

    Create_function_step_func = proc (para1: Pcontext; para2: int32; para3: PValueArg) {...}{.
        cdecl.}

  Source Edit

    Create_function_func_func = proc (para1: Pcontext; para2: int32; para3: PValueArg) {...}{.
        cdecl.}

  Source Edit

    Create_function_final_func = proc (para1: Pcontext) {...}{.cdecl.}

  Source Edit

    Result_func = proc (para1: pointer) {...}{.cdecl.}

  Source Edit

    Create_collation_func = proc (para1: pointer; para2: int32; para3: pointer; para4: int32;
                               para5: pointer): int32 {...}{.cdecl.}

  Source Edit

    Collation_needed_func = proc (para1: pointer; para2: PSqlite3; eTextRep: int32;
                               para4: cstring) {...}{.cdecl.}

  Source Edit

# Consts

    SQLITE_INTEGER = 1

  Source Edit

    SQLITE_FLOAT = 2

  Source Edit

    SQLITE_BLOB = 4

  Source Edit

    SQLITE_NULL = 5

  Source Edit

    SQLITE_TEXT = 3

  Source Edit

    SQLITE_UTF8 = 1

  Source Edit

    SQLITE_UTF16LE = 2

  Source Edit

    SQLITE_UTF16BE = 3

  Source Edit

    SQLITE_UTF16 = 4

  Source Edit

    SQLITE_ANY = 5

  Source Edit

    SQLITE_OK = 0

  Source Edit

    SQLITE_ERROR = 1

  Source Edit

    SQLITE_INTERNAL = 2

  Source Edit

    SQLITE_PERM = 3

  Source Edit

    SQLITE_ABORT = 4

  Source Edit

    SQLITE_BUSY = 5

  Source Edit

    SQLITE_LOCKED = 6

  Source Edit

    SQLITE_NOMEM = 7

  Source Edit

    SQLITE_READONLY = 8

  Source Edit

    SQLITE_INTERRUPT = 9

  Source Edit

    SQLITE_IOERR = 10

  Source Edit

    SQLITE_CORRUPT = 11

  Source Edit

    SQLITE_NOTFOUND = 12

  Source Edit

    SQLITE_FULL = 13

  Source Edit

    SQLITE_CANTOPEN = 14

  Source Edit

    SQLITE_PROTOCOL = 15

  Source Edit

    SQLITE_EMPTY = 16

  Source Edit

    SQLITE_SCHEMA = 17

  Source Edit

    SQLITE_TOOBIG = 18

  Source Edit

    SQLITE_CONSTRAINT = 19

  Source Edit

    SQLITE_MISMATCH = 20

  Source Edit

    SQLITE_MISUSE = 21

  Source Edit

    SQLITE_NOLFS = 22

  Source Edit

    SQLITE_AUTH = 23

  Source Edit

    SQLITE_FORMAT = 24

  Source Edit

    SQLITE_RANGE = 25

  Source Edit

    SQLITE_NOTADB = 26

  Source Edit

    SQLITE_ROW = 100

  Source Edit

    SQLITE_DONE = 101

  Source Edit

    SQLITE_COPY = 0

  Source Edit

    SQLITE_CREATE_INDEX = 1

  Source Edit

    SQLITE_CREATE_TABLE = 2

  Source Edit

    SQLITE_CREATE_TEMP_INDEX = 3

  Source Edit

    SQLITE_CREATE_TEMP_TABLE = 4

  Source Edit

    SQLITE_CREATE_TEMP_TRIGGER = 5

  Source Edit

    SQLITE_CREATE_TEMP_VIEW = 6

  Source Edit

    SQLITE_CREATE_TRIGGER = 7

  Source Edit

    SQLITE_CREATE_VIEW = 8

  Source Edit

    SQLITE_DELETE = 9

  Source Edit

    SQLITE_DROP_INDEX = 10

  Source Edit

    SQLITE_DROP_TABLE = 11

  Source Edit

    SQLITE_DROP_TEMP_INDEX = 12

  Source Edit

    SQLITE_DROP_TEMP_TABLE = 13

  Source Edit

    SQLITE_DROP_TEMP_TRIGGER = 14

  Source Edit

    SQLITE_DROP_TEMP_VIEW = 15

  Source Edit

    SQLITE_DROP_TRIGGER = 16

  Source Edit

    SQLITE_DROP_VIEW = 17

  Source Edit

    SQLITE_INSERT = 18

  Source Edit

    SQLITE_PRAGMA = 19

  Source Edit

    SQLITE_READ = 20

  Source Edit

    SQLITE_SELECT = 21

  Source Edit

    SQLITE_TRANSACTION = 22

  Source Edit

    SQLITE_UPDATE = 23

  Source Edit

    SQLITE_ATTACH = 24

  Source Edit

    SQLITE_DETACH = 25

  Source Edit

    SQLITE_ALTER_TABLE = 26

  Source Edit

    SQLITE_REINDEX = 27

  Source Edit

    SQLITE_DENY = 1

  Source Edit

    SQLITE_IGNORE = 2

  Source Edit

    SQLITE_DETERMINISTIC = 0x00000000

  Source Edit

    SQLITE_STATIC = nil

  Source Edit

    SQLITE_TRANSIENT = -1

  Source Edit

# Procs

    proc close(para1: PSqlite3): int32 {...}{.cdecl, dynlib: Lib, importc: "sqlite3_close".}

  Source Edit

    proc exec(para1: PSqlite3; sql: cstring; para3: Callback; para4: pointer;
             errmsg: var cstring): int32 {...}{.cdecl, dynlib: Lib, importc: "sqlite3_exec".}

  Source Edit

    proc last_insert_rowid(para1: PSqlite3): int64 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_last_insert_rowid".}

  Source Edit

    proc changes(para1: PSqlite3): int32 {...}{.cdecl, dynlib: Lib, importc: "sqlite3_changes".}

  Source Edit

    proc total_changes(para1: PSqlite3): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_total_changes".}

  Source Edit

    proc interrupt(para1: PSqlite3) {...}{.cdecl, dynlib: Lib, importc: "sqlite3_interrupt".}

  Source Edit

    proc complete(sql: cstring): int32 {...}{.cdecl, dynlib: Lib, importc: "sqlite3_complete".}

  Source Edit

    proc complete16(sql: pointer): int32 {...}{.cdecl, dynlib: Lib,
                                       importc: "sqlite3_complete16".}

  Source Edit

    proc busy_handler(para1: PSqlite3;
                     para2: proc (para1: pointer; para2: int32): int32 {...}{.cdecl.};
                     para3: pointer): int32 {...}{.cdecl, dynlib: Lib,
                                           importc: "sqlite3_busy_handler".}

  Source Edit

    proc busy_timeout(para1: PSqlite3; ms: int32): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_busy_timeout".}

  Source Edit

    proc get_table(para1: PSqlite3; sql: cstring; resultp: var cstringArray;
                  nrow, ncolumn: var cint; errmsg: ptr cstring): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_get_table".}

  Source Edit

    proc free_table(result: cstringArray) {...}{.cdecl, dynlib: Lib,
                                         importc: "sqlite3_free_table".}

  Source Edit

    proc mprintf(para1: cstring): cstring {...}{.cdecl, varargs, dynlib: Lib,
                                        importc: "sqlite3_mprintf".}

  Source Edit

    proc free(z: cstring) {...}{.cdecl, dynlib: Lib, importc: "sqlite3_free".}

  Source Edit

    proc snprintf(para1: int32; para2: cstring; para3: cstring): cstring {...}{.cdecl,
        dynlib: Lib, varargs, importc: "sqlite3_snprintf".}

  Source Edit

    proc set_authorizer(para1: PSqlite3; xAuth: proc (para1: pointer; para2: int32;
        para3: cstring; para4: cstring; para5: cstring; para6: cstring): int32 {...}{.cdecl.};
                       pUserData: pointer): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_set_authorizer".}

  Source Edit

    proc trace(para1: PSqlite3; xTrace: proc (para1: pointer; para2: cstring) {...}{.cdecl.};
              para3: pointer): pointer {...}{.cdecl, dynlib: Lib, importc: "sqlite3_trace".}

  Source Edit

    proc progress_handler(para1: PSqlite3; para2: int32;
                         para3: proc (para1: pointer): int32 {...}{.cdecl.}; para4: pointer) {...}{.
        cdecl, dynlib: Lib, importc: "sqlite3_progress_handler".}

  Source Edit

    proc commit_hook(para1: PSqlite3; para2: proc (para1: pointer): int32 {...}{.cdecl.};
                    para3: pointer): pointer {...}{.cdecl, dynlib: Lib,
                                            importc: "sqlite3_commit_hook".}

  Source Edit

    proc open(filename: cstring; ppDb: var PSqlite3): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_open".}

  Source Edit

    proc open16(filename: pointer; ppDb: var PSqlite3): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_open16".}

  Source Edit

    proc errcode(db: PSqlite3): int32 {...}{.cdecl, dynlib: Lib, importc: "sqlite3_errcode".}

  Source Edit

    proc errmsg(para1: PSqlite3): cstring {...}{.cdecl, dynlib: Lib, importc: "sqlite3_errmsg".}

  Source Edit

    proc errmsg16(para1: PSqlite3): pointer {...}{.cdecl, dynlib: Lib,
                                          importc: "sqlite3_errmsg16".}

  Source Edit

    proc prepare(db: PSqlite3; zSql: cstring; nBytes: int32; ppStmt: var PStmt;
                pzTail: ptr cstring): int32 {...}{.cdecl, dynlib: Lib,
                                          importc: "sqlite3_prepare".}

  Source Edit

    proc prepare_v2(db: PSqlite3; zSql: cstring; nByte: cint; ppStmt: var PStmt;
                   pzTail: ptr cstring): cint {...}{.importc: "sqlite3_prepare_v2", cdecl,
                                            dynlib: Lib.}

  Source Edit

    proc prepare16(db: PSqlite3; zSql: pointer; nBytes: int32; ppStmt: var PStmt;
                  pzTail: var pointer): int32 {...}{.cdecl, dynlib: Lib,
                                            importc: "sqlite3_prepare16".}

  Source Edit

    proc bind_blob(para1: PStmt; para2: int32; para3: pointer; n: int32;
                  para5: Tbind_destructor_func): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_bind_blob".}

  Source Edit

    proc bind_double(para1: PStmt; para2: int32; para3: float64): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_bind_double".}

  Source Edit

    proc bind_int(para1: PStmt; para2: int32; para3: int32): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_bind_int".}

  Source Edit

    proc bind_int64(para1: PStmt; para2: int32; para3: int64): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_bind_int64".}

  Source Edit

    proc bind_null(para1: PStmt; para2: int32): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_bind_null".}

  Source Edit

    proc bind_text(para1: PStmt; para2: int32; para3: cstring; n: int32;
                  para5: Tbind_destructor_func): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_bind_text".}

  Source Edit

    proc bind_text16(para1: PStmt; para2: int32; para3: pointer; para4: int32;
                    para5: Tbind_destructor_func): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_bind_text16".}

  Source Edit

    proc bind_blob(para1: PStmt; para2: int32; para3: pointer; n: int32; para5: int32): int32 {...}{.
        cdecl, dynlib: Lib, importc: "sqlite3_bind_blob".}

  Source Edit

    proc bind_text(para1: PStmt; para2: int32; para3: cstring; n: int32; para5: int32): int32 {...}{.
        cdecl, dynlib: Lib, importc: "sqlite3_bind_text".}

  Source Edit

    proc bind_text16(para1: PStmt; para2: int32; para3: pointer; para4: int32; para5: int32): int32 {...}{.
        cdecl, dynlib: Lib, importc: "sqlite3_bind_text16".}

  Source Edit

    proc bind_parameter_count(para1: PStmt): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_bind_parameter_count".}

  Source Edit

    proc bind_parameter_name(para1: PStmt; para2: int32): cstring {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_bind_parameter_name".}

  Source Edit

    proc bind_parameter_index(para1: PStmt; zName: cstring): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_bind_parameter_index".}

  Source Edit

    proc clear_bindings(para1: PStmt): int32 {...}{.cdecl, dynlib: Lib,
                                           importc: "sqlite3_clear_bindings".}

  Source Edit

    proc column_count(PStmt: PStmt): int32 {...}{.cdecl, dynlib: Lib,
                                         importc: "sqlite3_column_count".}

  Source Edit

    proc column_name(para1: PStmt; para2: int32): cstring {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_column_name".}

  Source Edit

    proc column_table_name(para1: PStmt; para2: int32): cstring {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_column_table_name".}

  Source Edit

    proc column_name16(para1: PStmt; para2: int32): pointer {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_column_name16".}

  Source Edit

    proc column_decltype(para1: PStmt; i: int32): cstring {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_column_decltype".}

  Source Edit

    proc column_decltype16(para1: PStmt; para2: int32): pointer {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_column_decltype16".}

  Source Edit

    proc step(para1: PStmt): int32 {...}{.cdecl, dynlib: Lib, importc: "sqlite3_step".}

  Source Edit

    proc data_count(PStmt: PStmt): int32 {...}{.cdecl, dynlib: Lib,
                                       importc: "sqlite3_data_count".}

  Source Edit

    proc column_blob(para1: PStmt; iCol: int32): pointer {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_column_blob".}

  Source Edit

    proc column_bytes(para1: PStmt; iCol: int32): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_column_bytes".}

  Source Edit

    proc column_bytes16(para1: PStmt; iCol: int32): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_column_bytes16".}

  Source Edit

    proc column_double(para1: PStmt; iCol: int32): float64 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_column_double".}

  Source Edit

    proc column_int(para1: PStmt; iCol: int32): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_column_int".}

  Source Edit

    proc column_int64(para1: PStmt; iCol: int32): int64 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_column_int64".}

  Source Edit

    proc column_text(para1: PStmt; iCol: int32): cstring {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_column_text".}

  Source Edit

    proc column_text16(para1: PStmt; iCol: int32): pointer {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_column_text16".}

  Source Edit

    proc column_type(para1: PStmt; iCol: int32): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_column_type".}

  Source Edit

    proc finalize(PStmt: PStmt): int32 {...}{.cdecl, dynlib: Lib, importc: "sqlite3_finalize".}

  Source Edit

    proc reset(PStmt: PStmt): int32 {...}{.cdecl, dynlib: Lib, importc: "sqlite3_reset".}

  Source Edit

    proc create_function(para1: PSqlite3; zFunctionName: cstring; nArg: int32;
                        eTextRep: int32; para5: pointer;
                        xFunc: Create_function_func_func;
                        xStep: Create_function_step_func;
                        xFinal: Create_function_final_func): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_create_function".}

  Source Edit

    proc create_function16(para1: PSqlite3; zFunctionName: pointer; nArg: int32;
                          eTextRep: int32; para5: pointer;
                          xFunc: Create_function_func_func;
                          xStep: Create_function_step_func;
                          xFinal: Create_function_final_func): int32 {...}{.cdecl,
        dynlib: Lib, importc: "sqlite3_create_function16".}

  Source Edit

    proc aggregate_count(para1: Pcontext): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_aggregate_count".}

  Source Edit

    proc value_blob(para1: PValue): pointer {...}{.cdecl, dynlib: Lib,
                                          importc: "sqlite3_value_blob".}

  Source Edit

    proc value_bytes(para1: PValue): int32 {...}{.cdecl, dynlib: Lib,
                                         importc: "sqlite3_value_bytes".}

  Source Edit

    proc value_bytes16(para1: PValue): int32 {...}{.cdecl, dynlib: Lib,
                                           importc: "sqlite3_value_bytes16".}

  Source Edit

    proc value_double(para1: PValue): float64 {...}{.cdecl, dynlib: Lib,
                                            importc: "sqlite3_value_double".}

  Source Edit

    proc value_int(para1: PValue): int32 {...}{.cdecl, dynlib: Lib, importc: "sqlite3_value_int".}

  Source Edit

    proc value_int64(para1: PValue): int64 {...}{.cdecl, dynlib: Lib,
                                         importc: "sqlite3_value_int64".}

  Source Edit

    proc value_text(para1: PValue): cstring {...}{.cdecl, dynlib: Lib,
                                          importc: "sqlite3_value_text".}

  Source Edit

    proc value_text16(para1: PValue): pointer {...}{.cdecl, dynlib: Lib,
                                            importc: "sqlite3_value_text16".}

  Source Edit

    proc value_text16le(para1: PValue): pointer {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_value_text16le".}

  Source Edit

    proc value_text16be(para1: PValue): pointer {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_value_text16be".}

  Source Edit

    proc value_type(para1: PValue): int32 {...}{.cdecl, dynlib: Lib,
                                        importc: "sqlite3_value_type".}

  Source Edit

    proc aggregate_context(para1: Pcontext; nBytes: int32): pointer {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_aggregate_context".}

  Source Edit

    proc user_data(para1: Pcontext): pointer {...}{.cdecl, dynlib: Lib,
                                           importc: "sqlite3_user_data".}

  Source Edit

    proc get_auxdata(para1: Pcontext; para2: int32): pointer {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_get_auxdata".}

  Source Edit

    proc set_auxdata(para1: Pcontext; para2: int32; para3: pointer;
                    para4: proc (para1: pointer) {...}{.cdecl.}) {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_set_auxdata".}

  Source Edit

    proc result_blob(para1: Pcontext; para2: pointer; para3: int32; para4: Result_func) {...}{.
        cdecl, dynlib: Lib, importc: "sqlite3_result_blob".}

  Source Edit

    proc result_double(para1: Pcontext; para2: float64) {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_result_double".}

  Source Edit

    proc result_error(para1: Pcontext; para2: cstring; para3: int32) {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_result_error".}

  Source Edit

    proc result_error16(para1: Pcontext; para2: pointer; para3: int32) {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_result_error16".}

  Source Edit

    proc result_int(para1: Pcontext; para2: int32) {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_result_int".}

  Source Edit

    proc result_int64(para1: Pcontext; para2: int64) {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_result_int64".}

  Source Edit

    proc result_null(para1: Pcontext) {...}{.cdecl, dynlib: Lib, importc: "sqlite3_result_null".}

  Source Edit

    proc result_text(para1: Pcontext; para2: cstring; para3: int32; para4: Result_func) {...}{.
        cdecl, dynlib: Lib, importc: "sqlite3_result_text".}

  Source Edit

    proc result_text16(para1: Pcontext; para2: pointer; para3: int32; para4: Result_func) {...}{.
        cdecl, dynlib: Lib, importc: "sqlite3_result_text16".}

  Source Edit

    proc result_text16le(para1: Pcontext; para2: pointer; para3: int32; para4: Result_func) {...}{.
        cdecl, dynlib: Lib, importc: "sqlite3_result_text16le".}

  Source Edit

    proc result_text16be(para1: Pcontext; para2: pointer; para3: int32; para4: Result_func) {...}{.
        cdecl, dynlib: Lib, importc: "sqlite3_result_text16be".}

  Source Edit

    proc result_value(para1: Pcontext; para2: PValue) {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_result_value".}

  Source Edit

    proc create_collation(para1: PSqlite3; zName: cstring; eTextRep: int32; para4: pointer;
                         xCompare: Create_collation_func): int32 {...}{.cdecl, dynlib: Lib,
        importc: "sqlite3_create_collation".}

  Source Edit

    proc create_collation16(para1: PSqlite3; zName: cstring; eTextRep: int32;
                           para4: pointer; xCompare: Create_collation_func): int32 {...}{.
        cdecl, dynlib: Lib, importc: "sqlite3_create_collation16".}

  Source Edit

    proc collation_needed(para1: PSqlite3; para2: pointer; para3: Collation_needed_func): int32 {...}{.
        cdecl, dynlib: Lib, importc: "sqlite3_collation_needed".}

  Source Edit

    proc collation_needed16(para1: PSqlite3; para2: pointer; para3: Collation_needed_func): int32 {...}{.
        cdecl, dynlib: Lib, importc: "sqlite3_collation_needed16".}

  Source Edit

    proc libversion(): cstring {...}{.cdecl, dynlib: Lib, importc: "sqlite3_libversion".}

  Source Edit

    proc version(): cstring {...}{.cdecl, dynlib: Lib, importc: "sqlite3_libversion".}

  Source Edit

    proc libversion_number(): int32 {...}{.cdecl, dynlib: Lib,
                                   importc: "sqlite3_libversion_number".}

  Source Edit