I would suspect this is "DB Browser for SQLite" application. It has an 'execute SQL' tab, so the raw code can be directly entered, or the table modified through a gui. It's pretty straightforward to use, and had a wiki on its support pages. This isn't the place to guide you though, but it has a very active support group.
Thanks, Chris On 24 Dec 2017 7:17 am, "Keith Medcalf" <[email protected]> wrote: > > 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 SQLite3 command line shell. > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > > >-----Original Message----- > >From: sqlite-users [mailto:sqlite-users- > >[email protected]] On Behalf Of Miel Loinaz > >Sent: Saturday, 23 December, 2017 21:34 > >To: [email protected] > >Subject: [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 = datetime (date1, 'unixepoch', 'localtime'); > > > >But I do not know how to modify the sqlite database with DB Browser, > >I'm a > >newbie. Where should I enter this code? > > > >Thanks and Merry Christmas! > >_______________________________________________ > >sqlite-users mailing list > >[email protected] > >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
