Mardulu
Reputation: 91
SQLite: How to check if there is another row of data without moving cursor?
Is it possible to find out if there is another row of data available after a "select" query without moving the cursor by calling "sqlite3_step" again?
Upvotes: 0
Views: 78
Answers (1)
CL.
Reputation: 180182
SQLite computes the output rows dynamically, when needed.
So it is not possible to find out if you can get another row without actually trying to step to that row.
Upvotes: 1
Related Questions
- How to check the existence of a row in SQLite with Python?
- check if row already exist in sqlite database
- Ensure SQLite table only has one row
- Check if row with value already exists in SQLite table
- SQLite: detect if a rowid exists
- Checking one row against the next in SQL
- How to know if a row doesn't exist?
- Sqlite verify if value of column exists
- How to check whether the specific value exists in a column?
- Android find if rowID exists using Cursor?