Re: [sqlite] Location of error in SQL statements ?

2019-05-07 Thread x
I think pzTail just points to the trailing ‘/0’ of zSql if an error occurs. From: sqlite-users on behalf of Rowan Worth Sent: Tuesday, May 7, 2019 9:07:34 AM To: SQLite mailing list Subject: Re: [sqlite] Location of error in SQL statements ? On Tue, 7 May

Re: [sqlite] Location of error in SQL statements ?

2019-05-07 Thread Rowan Worth
On Tue, 7 May 2019 at 16:00, Eric Grange wrote: > Is there are way to get more information about an SQL syntax error message > ? > For example on a largish SQL query I got the following error message > > near "on": syntax error > > but as the query is basically a long list of joins, this

[sqlite] Location of error in SQL statements ?

2019-05-07 Thread Eric Grange
Hi, Is there are way to get more information about an SQL syntax error message ? For example on a largish SQL query I got the following error message near "on": syntax error but as the query is basically a long list of joins, this is not too helpful ;) Having a character offset, a line