SqlQuery()


cursor = SqlQuery(n, table$, where$, order$, Col1$, Col2$, ...)

This function performs a SQLite query on the given (table$) in database file number (n). A SQLite Cursor object is returned.

The (where$) parameter specifies the SQLite where clause. This selects the records to be included by the cursor.

The (order$) parameter specifies the sort order of the records.

Next follows a list of the column names in the order you wish them to appear in the records returned.

cursor = SqlQuery(1, "People", "LastName = 'Robinson'", "Age", "FirstName", "LastName", "Age")


cursor = SqlQueryA(n, table$, where$, order$, columns$())

This function works the same as an SqlQuery() but the column names are stored in a string array.


cursor = SqlQueryI(n, table$, where$, order$, columns$, {delimiter$})

This function works the same as an SqlQuery() but the column names are stored in itemized string.

The optional delimiter$ specifies the string delimiter character. If omitted, the delimiter character defaults to a comma.


Every SqlQuery must have a corresponding SqlCloseCursor.


SQLite


SQLite Cursor


SqlCursor()


SqlCloseCursor


SqlQueryRaw()






Become a Patron