sqlite3_step() has another row ready

SQLITE_ROW (100) is returned by sqlite3_step() each time a new row of data is ready to be read from a SELECT statement. The calling code should call sqlite3_column_*() to retrieve the row data, then call sqlite3_step() again for the next row.

1. 1Not an error — indicates a row is available.

Returned by sqlite3_step() for each row of a SELECT result set.

import sqlite3
conn = sqlite3.connect(':memory:')
conn.execute('CREATE TABLE t(x)')
conn.executemany('INSERT INTO t VALUES(?)', [(1,),(2,),(3,)])
for row in conn.execute('SELECT x FROM t'):
    print(row)  # Python driver calls step() internally

(1,)
(2,)
(3,)

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev