When I attempt to prepare the following statement using sqlite3_prepare:
SELECT id FROM testEntity LIMIT 5 OFFSET ?;
I get the following error back from SQLite:
near "?": syntax error
Is this really not allowed? If so, that seems a bit odd to me. This seems like a classic use-case for prepared statements (re-running the same query with different offsets).
Or is there something else I'm missing?
-Eric
(FWIW, I'm using SQLite 3.0.8 on Mac OS X.)