Small. Fast. Reliable.
Choose any three.

SQLite Requirement Matrix Details
free_table.html

Index Summary Markup Original


R-45075-05696-46728-36342-39076-34346-28499-29393 tcl slt th3 src

As an example of the result table format, suppose a query result is as follows:

Name        | Age
-----------------------
Alice       | 43
Bob         | 28
Cindy       | 21

There are two columns (M==2) and three rows (N==3). Thus the result table has 8 entries. Suppose the result table is stored in an array named azResult. Then azResult holds this content:

azResult[0] = "Name";
azResult[1] = "Age";
azResult[2] = "Alice";
azResult[3] = "43";
azResult[4] = "Bob";
azResult[5] = "28";
azResult[6] = "Cindy";
azResult[7] = "21";

th3/req1/gettable01.test:17

/* IMP: R-45075-05696 */
# EVIDENCE-OF: R-45075-05696 As an example of the result table format,
# suppose a query result is as follows: Name | Age
# ----------------------- Alice | 43 Bob | 28 Cindy | 21 There are two
# columns (M==2) and three rows (N==3). Thus the result table has 8
# entries. Suppose the result table is stored in an array named
# azResult. Then azResult holds this content: azResult[0] = "Name";
# azResult[1] = "Age"; azResult[2] = "Alice"; azResult[3] = "43";
# azResult[4] = "Bob"; azResult[5] = "28"; azResult[6] = "Cindy";
# azResult[7] = "21";

R-00421-53597-33844-16365-55873-40811-64785-22587 tcl slt th3 src

The sqlite3_get_table() function evaluates one or more semicolon-separated SQL statements in the zero-terminated UTF-8 string of its 2nd parameter and returns a result table to the pointer given in its 3rd parameter.

th3/req1/gettable01.test:51

/* IMP: R-00421-53597 */
# EVIDENCE-OF: R-00421-53597 The sqlite3_get_table() function evaluates
# one or more semicolon-separated SQL statements in the zero-terminated
# UTF-8 string of its 2nd parameter and returns a result table to the
# pointer given in its 3rd parameter.