Yes, thanks I understand now. I take it there is no way to make it not return the field name.
RBS -----Original Message----- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: 06 March 2007 19:53 To: SQLite Subject: [sqlite] Re: What is wrong with this simple query (offset)? RB Smissaert <[EMAIL PROTECTED]> wrote: > Why does this query give a syntax error near offset? > > SELECT > Name > FROM SQLITE_MASTER > WHERE TYPE = 'table' > ORDER BY 1 ASC > offset 2 The syntax doesn't allow OFFSET on its own, but only together with LIMIT. Make it LIMIT -1 OFFSET 2 -- or LIMIT 2, -1 -1 means no limit. Igor Tandetnik ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------