Thanks Tim I am not concerned with errors from function calls - just errors with SQL queries at the command line etc. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence
On 19 March 2016 at 11:20, Tim Streater <tim at clothears.org.uk> wrote: > On 19 Mar 2016 at 10:26, Paul Sanderson <sandersonforensics at gmail.com> > wrote: > >> When executing a sql query I often find I have made a typo or been a >> bit dull and I'll get an error message back along the lines of >> >> Error: near "text": syntax error >> >> Is there a way of expanding on this, for instance adding more of the >> following text or a character offset. The last time this happened I >> had a create table... command with about 30 text columns and >> identifying which "text" string the error referred to took a little >> while. > > In my PHP usage of SQLite, I have a shim around the provided functions which > logs the SQL in the event of error. The application then displays it too. The > shim also expects a small string to identify which actual SQLite call was > involved, so I don't have to look through 140 source modules trying to guess > what was going on at the time. > > -- > Cheers -- Tim > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >