On Tue, 7 May 2019 at 16:00, Eric Grange <zar...@gmail.com> 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 is not too helpful > ;) >
It's not clear from the docs whether this is guaranteed, but a quick look at the code suggests that the pzTail argument (if provided to sqlite3_prepare_v2) is also updated when there's a parse error. You might be able to rely on that to infer how far through the statement the problem lies. -Rowan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users