sqlite row

The sqlite row type represents one row in the output of a select query.

Creation
Properties
Casts

Version	Platforms
9.0.586.0	AIX, Debian, HP-UX, Mac, Red Hat, SUSE, Solaris, Ubuntu, Windows
9.5.13.130	Raspbian

Creation

row of <sqlite statement> : sqlite row

Returns the result of the select query. The rows are written as a list of CSV strings. Decimal numbers are set to display 3 decimal places. Due to the difficulty in displaying blobs, in which one cell could be hundreds of lines, if a cell in a table is a BLOB type, then "Blob" is displayed. Likewise, if a cell in a table is NULL, then "NULL" is displayed.

Q: rows of statement "select * from Artist limit 5" of sqlite database of file "chinook.db"
A: 1,AC/DC
A: 2,Accept
A: 3,Aerosmith
A: 4,Alanis Morissette
A: 5,Alice In Chains

Plural: rows

Version	Platforms
9.0.586.0	AIX, Debian, HP-UX, Mac, Red Hat, SUSE, Solaris, Ubuntu, Windows
9.5.13.130	Raspbian

permalink source

Properties

column <integer> of <sqlite row> : sqlite column

Returns the values of the nth column of a select query. The first column is 0.

Q: columns 1 of rows of statement "select ArtistId, Name from Artist limit 5" of sqlite database of file "chinook.db"
A: AC/DC
A: Accept
A: Aerosmith
A: Alanis Morissette
A: Alice In Chains

Plural: columns

Version	Platforms
9.0.586.0	AIX, Debian, HP-UX, Mac, Red Hat, SUSE, Solaris, Ubuntu, Windows
9.5.13.130	Raspbian

permalink source

column <string> of <sqlite row> : sqlite column

Returns the values of the named column of the select query.

Q: columns "ArtistId" of rows of statement "select ArtistId, Name from Artist limit 5" of sqlite database of file "chinook.db"
A: 1
A: 2
A: 3
A: 4
A: 5

Plural: columns

Version	Platforms
9.0.586.0	AIX, Debian, HP-UX, Mac, Red Hat, SUSE, Solaris, Ubuntu, Windows
9.5.13.130	Raspbian

permalink source

Casts

<sqlite row> as string : string

Write the columns in the row as a CSV string.

Q: rows of statement "select * from Artist limit 5" of sqlite database of file "chinook.db" as string
A: 1,AC/DC
A: 2,Accept
A: 3,Aerosmith
A: 4,Alanis Morissette
A: 5,Alice In Chains

Version	Platforms
9.0.586.0	AIX, Debian, HP-UX, Mac, Red Hat, SUSE, Solaris, Ubuntu, Windows
9.5.13.130	Raspbian

permalink source