Re: [sqlite] Last record

2019-10-15 Thread Chris Green
rd in advance from sqlite3_step. > What do you mean by "last record"? -- Chris Green · ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

2018-10-11 Thread Chris Green
Darren Duncan wrote: > On 2018-10-10 10:51 AM, Chris Green wrote: > > Warren Young wrote: > >> Fossil forum email alerts include the full content of the message. > > That's great! Especially if the alert email subject includes the forum > thread > subje

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

2018-10-10 Thread Chris Green
o go and get them > >> > >> So do Fossil email alerts. > > > > So there's an unecessary email I've just received telling me to go to the > > forum. > > Fossil forum email alerts include the full content of the message. And can you then si

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

2018-10-10 Thread Chris Green
Gary R. Schmidt wrote: > On 10/10/2018 22:20, Petite Abeille wrote: > > > [SNIP] > > ( Also, fwiw: please keep the mailing list, it's perfectly functional as > > is. ) > > > Seconded. > > It isn't broken, so please don't try and fi

Re: [sqlite] Easiest way to get day of week as a string (not a number)?

2018-02-01 Thread Chris Green
presumably that works with the locale setting to give them to you in your own language. -- Chris Green · ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Easiest way to get day of week as a string (not a number)?

2018-02-01 Thread Chris Green
x <tam118...@hotmail.com> wrote: > Don’t think you’ll get it any less ugly than > > substr('SunMonTueWedThuFriSat',strftime('%w',Date)*3+1,3); > Yes, thanks, that's where I had got to! :-) -- Chris Green · ___ sqlite-users mailing

[sqlite] Easiest way to get day of week as a string (not a number)?

2018-02-01 Thread Chris Green
I want to get Sun, Mon, Tue, Wed etc. from a date, what's the easiest way of doing this in a sqlite select? I guess I can do something (horrible?) with the numeric day of week and substr() but is there not an easier way? -- Chris Green · ___ sqlite

Re: [sqlite] Need some help running sqlite3 command line

2017-03-07 Thread Chris Green
Jacob Sylvia <jacob.syl...@gmail.com> wrote: > I know what the problem was... bash was interpreting the `table_name` piece > as a command. I had to escape the backticks... > Yes, `command` is the old-fashioned way of saying $(command) in bash.

Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

2012-01-17 Thread Chris Green
On Tue, Jan 17, 2012 at 06:21:48PM +0100, noel.frankinet wrote: > Le 17/01/2012 18:15, Chris Green a écrit : > > Hello Chris, > > You should look at Dojo javascript library, I think they have the > widget you are looking for. Of course you still need the back-end > pl

Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

2012-01-17 Thread Chris Green
doesn't edit in situ. To edit a row you have to click on the row and then move up to the row at the top and change the values there. ... and *then* you have to click on the Update Table button to put the values back into the table. > On Tue, Jan 17, 2012 at 8:05 AM, Chris Green <c...@isbd.net&

[sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

2012-01-17 Thread Chris Green
want to have to navigate through menus and options to get there. Any ideas or suggestions would be very welcome. -- Chris Green ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users