---
title: "36 docs tagged with \"sqlite\" | open.mp"
canonical: https://omp.itsneufox.com/docs/tags/sqlite
language: en
---

# 36 docs tagged with "sqlite"

[View all tags](https://omp.itsneufox.com/docs/tags)

[

## db\_close

](https://omp.itsneufox.com/docs/scripting/functions/db_close)

Closes a SQLite database connection that was opened with \`db\_open\`.

[

## DB\_Close

](https://omp.itsneufox.com/docs/scripting/functions/DB_Close_Modern)

Closes a SQLite database connection that was opened with \`DB\_Open\`.

[

## db\_debug\_openfiles

](https://omp.itsneufox.com/docs/scripting/functions/db_debug_openfiles)

Gets the number of open database connections for debugging purposes.

[

## db\_debug\_openresults

](https://omp.itsneufox.com/docs/scripting/functions/db_debug_openresults)

Gets the number of open database results

[

## DB\_ExecuteQuery

](https://omp.itsneufox.com/docs/scripting/functions/DB_ExecuteQuery)

The function is used to execute an SQL query on an opened SQLite database.

[

## db\_field\_name

](https://omp.itsneufox.com/docs/scripting/functions/db_field_name)

Returns the name of the field at the specified index.

[

## db\_free\_result

](https://omp.itsneufox.com/docs/scripting/functions/db_free_result)

Frees result memory allocated from db\_query.

[

## DB\_FreeResultSet

](https://omp.itsneufox.com/docs/scripting/functions/DB_FreeResultSet)

Frees result memory allocated from DB\_ExecuteQuery.

[

## db\_get\_field

](https://omp.itsneufox.com/docs/scripting/functions/db_get_field)

Get the content of a field from db\_query.

[

## db\_get\_field\_assoc

](https://omp.itsneufox.com/docs/scripting/functions/db_get_field_assoc)

Gets the contents of the field as a string with the specified field name.

[

## db\_get\_field\_assoc\_float

](https://omp.itsneufox.com/docs/scripting/functions/db_get_field_assoc_float)

Gets the contents of the field as a floating point number with the specified field name.

[

## db\_get\_field\_assoc\_int

](https://omp.itsneufox.com/docs/scripting/functions/db_get_field_assoc_int)

Gets the contents of the field as an integer with the specified field name.

[

## db\_get\_field\_float

](https://omp.itsneufox.com/docs/scripting/functions/db_get_field_float)

Gets the content of a field as a floating point number with the specified field index.

[

## db\_get\_field\_int

](https://omp.itsneufox.com/docs/scripting/functions/db_get_field_int)

Get the content of a field as an integer from db\_query.

[

## db\_get\_mem\_handle

](https://omp.itsneufox.com/docs/scripting/functions/db_get_mem_handle)

Gets the memory handle for a SQLite database connection that was opened with \`db\_open\`.

[

## db\_get\_result\_mem\_handle

](https://omp.itsneufox.com/docs/scripting/functions/db_get_result_mem_handle)

Gets the memory handle for a SQLite database result set that was allocated with \`db\_query\`.

[

## DB\_GetDatabaseConnectionCount

](https://omp.itsneufox.com/docs/scripting/functions/DB_GetDatabaseConnectionCount)

Gets the number of open database connections for debugging purposes.

[

## DB\_GetDatabaseResultSetCount

](https://omp.itsneufox.com/docs/scripting/functions/DB_GetDatabaseResultSetCount)

Gets the number of open database results

[

## DB\_GetFieldCount

](https://omp.itsneufox.com/docs/scripting/functions/DB_GetFieldCount)

Gets the number of fields from the specified result set allocated with \`DB\_ExecuteQuery\`.

[

## DB\_GetFieldFloat

](https://omp.itsneufox.com/docs/scripting/functions/DB_GetFieldFloat)

Gets the content of a field as a floating point number with the specified field index.

[

## DB\_GetFieldFloatByName

](https://omp.itsneufox.com/docs/scripting/functions/DB_GetFieldFloatByName)

Gets the contents of the field as a floating point number with the specified field name.

[

## DB\_GetFieldInt

](https://omp.itsneufox.com/docs/scripting/functions/DB_GetFieldInt)

Get the content of a field as an integer from DB\_ExecuteQuery.

[

## DB\_GetFieldIntByName

](https://omp.itsneufox.com/docs/scripting/functions/DB_GetFieldIntByName)

Gets the contents of the field as an integer with the specified field name.

[

## DB\_GetFieldName

](https://omp.itsneufox.com/docs/scripting/functions/DB_GetFieldName)

Returns the name of the field at the specified index.

[

## DB\_GetFieldString

](https://omp.itsneufox.com/docs/scripting/functions/DB_GetFieldString)

Get the content of a field from DB\_ExecuteQuery.

[

## DB\_GetFieldStringByName

](https://omp.itsneufox.com/docs/scripting/functions/DB_GetFieldStringByName)

Gets the contents of the field as a string with the specified field name.

[

## DB\_GetLegacyDBResult

](https://omp.itsneufox.com/docs/scripting/functions/DB_GetLegacyDBResult)

Gets the memory handle for a SQLite database result set that was allocated with \`DB\_ExecuteQuery\`.

[

## DB\_GetMemHandle

](https://omp.itsneufox.com/docs/scripting/functions/DB_GetMemHandle)

Gets the memory handle for a SQLite database connection that was opened with \`DB\_Open\`.

[

## DB\_GetRowCount

](https://omp.itsneufox.com/docs/scripting/functions/DB_GetRowCount)

Returns the number of rows from a DB\_ExecuteQuery.

[

## db\_next\_row

](https://omp.itsneufox.com/docs/scripting/functions/db_next_row)

Moves to the next row of the result set allocated with \`db\_query\`.

[

## db\_num\_fields

](https://omp.itsneufox.com/docs/scripting/functions/db_num_fields)

Gets the number of fields from the specified result set allocated with \`db\_query\`.

[

## db\_num\_rows

](https://omp.itsneufox.com/docs/scripting/functions/db_num_rows)

Returns the number of rows from a db\_query.

[

## db\_open

](https://omp.itsneufox.com/docs/scripting/functions/db_open)

The function is used to open a connection to a SQLite database file, which is inside the \`/scriptfiles\` folder.

[

## DB\_Open

](https://omp.itsneufox.com/docs/scripting/functions/DB_Open_Modern)

The function is used to open a connection to a SQLite database file, which is inside the \`/scriptfiles\` folder.

[

## db\_query

](https://omp.itsneufox.com/docs/scripting/functions/db_query)

The function is used to execute an SQL query on an opened SQLite database.

[

## DB\_SelectNextRow

](https://omp.itsneufox.com/docs/scripting/functions/DB_SelectNextRow)

Moves to the next row of the result set allocated with \`DB\_ExecuteQuery\`.