Re: [sqlite] Modify the sqlite database with DB Browser to update a new field

This sounds like a "DB Browser" issue, whatever a "DB Browser" is. You should direct questions about how to enter SQL commands into "DB Browser" to the "DB Browser" support channel. This is especially true since it appears that you have solved the problem satisfactorily when using the

Re: [sqlite] Modify the sqlite database with DB Browser to update a new field

First, be careful with modifying a database you don't control. This can result in unexpected results, even if you're tailing onto the end of the table. Some calls are like [select * from ThisTable] and the code itself is expecting exactly the number of fields to be returned. You may also be

[sqlite] Modify the sqlite database with DB Browser to update a new field

Hello, I want to modify a sqlite database of a weather station software (wewx.sdb). Date and time are in the form of echo or linux time (field date1). I have added a new field (date2) where I want to display human readable date and time. In Linux console I get it running: UPDATE table1 SET date2

Re: [sqlite] INSERT OR REPLACE statement and triggers

Result of a test with recursive off then on. "before insert" fired on "insert or ignore" With recursive triggers on, the before and after delete triggers fired between the before and after insert triggers. SQLite version 3.21.0 2017-10-24 18:55:49 Enter ".help" for usage hints. Connected to a

Re: [sqlite] INSERT OR REPLACE statement and triggers

Hello, thanks for the documentation references! Regards, Hartwig > Am 2017-12-23 um 13:18 schrieb J. King : > > The documentation states that in cases of replacement the DELETE trigger only > fires if recursive triggers are enabled. Recursive triggers are currently off >

Re: [sqlite] .load fails

On 12/23/17, Richard Hipp wrote: > On 12/23/17, Joop! wrote: >> sqlite> *.load /usr/lib/sqlite3/pcre.so* >> *Error: /usr/lib/sqlite3/pcre.so.so: cannot open shared object file: No >> such file or directory* >> > > What error message do you get if you omit the

Re: [sqlite] .load fails

On 12/23/17, Joop! wrote: > sqlite> *.load /usr/lib/sqlite3/pcre.so* > *Error: /usr/lib/sqlite3/pcre.so.so: cannot open shared object file: No > such file or directory* > What error message do you get if you omit the ".so" at the end of the shared library name? -- D. Richard

Re: [sqlite] .load fails

Joop! wrote: >sqlite> .load /usr/lib/sqlite3/pcre.so >Error: /usr/lib/sqlite3/pcre.so.so: cannot open sqlite3 always adds ".so". Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] .load fails

Dear Supoport, *St**ep 1*: Check that the module pcre.so is available. ⋊> /m/f/U/OMT DB development ll /usr/lib/sqlite3/   

Re: [sqlite] INSERT OR REPLACE statement and triggers

The documentation states that in cases of replacement the DELETE trigger only fires if recursive triggers are enabled. Recursive triggers are currently off by default. On December 23, 2017

Re: [sqlite] INSERT OR REPLACE statement and triggers

On 2017/12/23 1:57 PM, skywind mailing lists wrote: Hello, I have checked the documentation but did not find an explicit answer concerning my case. Of course I can test it but this does not mean that the functionality is guaranteed also for future versions. Assume I have an insertion

[sqlite] INSERT OR REPLACE statement and triggers

Hello, I have checked the documentation but did not find an explicit answer concerning my case. Of course I can test it but this does not mean that the functionality is guaranteed also for future versions. Assume I have an insertion statement like INSERT OR REPLACE INTO TestTable VALUES(1,2);

Re: [sqlite] sqlite3 related crash (SIGSEGV) in GNOME tracker-store

On 12/23/2017 08:41 AM, Paul Wise wrote: On Fri, 2017-12-22 at 20:09 -0500, Richard Hipp wrote: Nevertheless, we will investigate from the SQLite side, just in case. If you need any information from the core dump, please let me know which gdb commands to run. I still have one available from