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
