On Thu, 23 Dec 2004 20:33:01 -0200, pascalive <[EMAIL PROTECTED]> wrote:

> I'd like to know if there's a way to retrieve the _rowid_ of each returned 
> row without asking for it.

Actually, this is something I've been meaning to feature-request, and
for exactly the same reason. What I do, and it is far from ideal, is
require the user to specify 'rowid' for queries that will ultimately
be used for updates. What would be neat, I think, is if there were a
PRAGMA we could add to a query that would tell SQLite to add the
'rowid' column to any result set for which 'rowid' wasn't already a
column.

Reply via email to