Re: [sqlite] Last record
Philippe RIO <51...@protonmail.ch> wrote: > A short question : how could I know if I am reading the last record with > sqlite (sqlite3_step)? sqlite3_step only returns SQLITE_ROW. Is there a > function for that case which returns SQLITE_DONE? A function which is one > record 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?]
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 > subject. > > That said, I consider it critical that these alert emails can also send my > own > posts in the forum and not just others. If they don't send for EVERY post, > the > emails aren't suitable for reading / backing up a thread in one place. > > > And can you then simply 'reply' from your E-Mail client? If not then > > it doesn't really help much. > > Actually it helps a lot. I think in practice most people using this forum > would > be reading a lot more than they post. So you can do your majority action of > reading in your email client with the forum alerts. In the rare situation > where > you want to reply, then you just switch over to the web forum. Yes, and there lies the rub, it's a window-swapping, mouse clicking hassle. If it was a mailing list I'd simply hit L[ist reply] and that would be it. -- 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?]
Warren Young wrote: > On Oct 10, 2018, at 11:23 AM, Tim Streater wrote: > > > > On 10 Oct 2018, at 18:10, Warren Young wrote: > > > >> On Oct 10, 2018, at 10:39 AM, Eric wrote: > >>> > >>> * mailing lists come to me, I don't have to 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 simply 'reply' from your E-Mail client? If not then it doesn't really help much. -- 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?]
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 fix it. > Exactly! :-) -- 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)?
R Smith <ryansmit...@gmail.com> wrote: > The reason day-names are not part of the standard set of date-time > functions is that they are not standard and certainly not international. > > For you it is "Mon, Tue, Wed, Thu, Fri, Sat Sun"... > > But for me it might be: > > "Lun, Mar, Mer, Jeu, Ven, Sam, Dim" or sometimes simply "Lu, Ma, Me, Je, > Ve, Sa, Di" etc. > But systems have language variables which tell which set to use. The C strftime function has just about every form of day and month name you can imagine and 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)?
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 list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Easiest way to get day of week as a string (not a number)?
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-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Need some help running sqlite3 command line
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. -- Chris Green · ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite
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 > plumbing (PHP I suppose). That seems rather a long way (in terms of the amount of programming that would be involved) from where I want to be. Dojo appears to be an excellent general purpose Javascript framework but doesn't really address my requirement directly. Note that while I *could* use a web application that isn't a requirement, a native Linux application running on my desktop is all I actually need. > Best wishes > > Noël > > >On Tue, Jan 17, 2012 at 08:36:11AM -0800, Matt Young wrote: > >>http://javascriptsource.com/forms/dynamic-table.html > >>Looks great if you operate from a browser. Can we still get sqlite > >>embedded into the browser, or do we have to plug it in? > >> > >That doesn't really do it for me, it 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> wrote: > >> > >>>I'm after an application which will allow me to enter data into a sqlite > >>>database using a 'grid' layout of the data. I.e. I want the existing > >>>contents of the database displayed as a table and I want to be able to > >>>click on a field in a row and just edit the data in place. In addition > >>>I want to be able to use the TAB key to move from field to field > >>>(another key would be OK, just not the mouse). There should be an empty > >>>row at the bottom for entering a new row. > >>> > >>>I'm happy to use a design tool of some sort to do this although a ready > >>>made application would be easier/quicker of course. I don't want to > >>>code the whole thing from scratch though. > >>> > >>>What I want is what MS Access calls a tabular form in its design wizard > >>>and is also what it presents you with by default if you open a table > >>>directly. > >>> > >>>I need this to run under Linux as a desktop application or alternatively > >>>a web application would be fine, I have apache2 with PHP etc. running on > >>>my desktop machine here. > >>> > >>>I've searched around quite a lot for something that can do this for me > >>>but haven't found anything yet. There are lots of database management > >>>programs (such as sqlitebrowser and sqliteman) but while they do a good > >>>job of managing a database they're really not built for entering data. > >>> > >>>I just want an executable I can run with database name and table name as > >>>parameters, e.g.:- > >>> > >>>myDataEditor somedatabase.db tablexyz > >>> > >>>... and it fires up a window with the rows/columns in a grid and allows > >>>me to edit. I don't 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 > >>> > >>___ > >>sqlite-users mailing list > >>sqlite-users@sqlite.org > >>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Chris Green ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite
On Tue, Jan 17, 2012 at 08:36:11AM -0800, Matt Young wrote: > http://javascriptsource.com/forms/dynamic-table.html > Looks great if you operate from a browser. Can we still get sqlite > embedded into the browser, or do we have to plug it in? > That doesn't really do it for me, it 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> wrote: > > > I'm after an application which will allow me to enter data into a sqlite > > database using a 'grid' layout of the data. I.e. I want the existing > > contents of the database displayed as a table and I want to be able to > > click on a field in a row and just edit the data in place. In addition > > I want to be able to use the TAB key to move from field to field > > (another key would be OK, just not the mouse). There should be an empty > > row at the bottom for entering a new row. > > > > I'm happy to use a design tool of some sort to do this although a ready > > made application would be easier/quicker of course. I don't want to > > code the whole thing from scratch though. > > > > What I want is what MS Access calls a tabular form in its design wizard > > and is also what it presents you with by default if you open a table > > directly. > > > > I need this to run under Linux as a desktop application or alternatively > > a web application would be fine, I have apache2 with PHP etc. running on > > my desktop machine here. > > > > I've searched around quite a lot for something that can do this for me > > but haven't found anything yet. There are lots of database management > > programs (such as sqlitebrowser and sqliteman) but while they do a good > > job of managing a database they're really not built for entering data. > > > > I just want an executable I can run with database name and table name as > > parameters, e.g.:- > > > >myDataEditor somedatabase.db tablexyz > > > > ... and it fires up a window with the rows/columns in a grid and allows > > me to edit. I don't 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 > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Chris Green ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite
I'm after an application which will allow me to enter data into a sqlite database using a 'grid' layout of the data. I.e. I want the existing contents of the database displayed as a table and I want to be able to click on a field in a row and just edit the data in place. In addition I want to be able to use the TAB key to move from field to field (another key would be OK, just not the mouse). There should be an empty row at the bottom for entering a new row. I'm happy to use a design tool of some sort to do this although a ready made application would be easier/quicker of course. I don't want to code the whole thing from scratch though. What I want is what MS Access calls a tabular form in its design wizard and is also what it presents you with by default if you open a table directly. I need this to run under Linux as a desktop application or alternatively a web application would be fine, I have apache2 with PHP etc. running on my desktop machine here. I've searched around quite a lot for something that can do this for me but haven't found anything yet. There are lots of database management programs (such as sqlitebrowser and sqliteman) but while they do a good job of managing a database they're really not built for entering data. I just want an executable I can run with database name and table name as parameters, e.g.:- myDataEditor somedatabase.db tablexyz ... and it fires up a window with the rows/columns in a grid and allows me to edit. I don't 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