---

C Library Functions  - sqlite3_get_table (3)

---

NAME

sqlite3_get_table(3f) - [M_sqlite] Call sqlite3_exec() and return the result in an array of strings

CONTENTS

Synopsis
Description
Options

SYNOPSIS

subroutine sqlite3_get_table(db, command, result, errmsg)

    type(SQLITE_DATABASE)    :: db
    character(len=*)         :: command
    character(len=*),pointer :: result(:)
    character(len=*)         :: errmsg

DESCRIPTION

Get the result of a query in a single two-dimensional array

Note:

      The result array is _nullified_ first, then allocated
      to hold the resulting table (within the limits of the
      character strings). It is up to the user to deallocate
      this array when done.

Further note:

      Because we have to split the process into two parts,
      to allocate an array that is large enough to hold all
      strings, use is made of a static variable. As a consequence
      this routine is _not_ thread-safe.

OPTIONS

db	Variable identifying the database connection
command
	The SQL command (query) to be executed
result	A two-dimensional array of strings that will be filled with the results of the SQL command. When done, you will have to deallocate it.
errmsg	Error message (if any). If there is an error, then "result" will not be allocated, and "errmsg" will contain the information about the error that occurred.

---

Nemo Release 3.1

sqlite3_get_table (3)

February 23, 2025

Generated by manServer 1.08 from a79d1f37-0109-4c33-802f-631d5f9ec446 using man macros.