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
