On Thu, Feb 04, 2016 at 10:15:27PM +0000, steve-ALUG@hst.me.uk wrote:
On 04/02/16 13:45, Chris Green wrote:
[]
You may remember I've been burbling on about a nice, easy, editable grid view of a database. That's the same requirement. I'm after a way of entering sequential sort of information, mostly free format text but also some specific numeric information that I want to be able to do calculations with. I also want to be able to see the 'surrounding context', i.e. the previous entry. Finally I want straightforward editing of existing entries, again with the ability to see the context while editing. It's nearly possible with a simple text file and a decent editor but this rather limits the validity checking. I have a boat log that works this way (written by me for Dokuwiki) but, having used it for a while, it has some drawbacks. In particular the syntax for the entries, while quite simple, is just a bit too difficult to remember without looking at some sort of cheat sheet. A more structured data entry system would make it work much better.
Well, the first line up there made me think of the data-entry grid view of a database. To be honest, I bet M$ Access would do it nicely for you, but
Yes, one of things that Access does rather well, an editable grid view of the database just comes with the territory *and* it's easy to incorporate in a form design.
you're not after Windows stuff, so perhaps there's an open source equivalent
- something in Libre Office perhaps? Or even just typing it into a
spreadsheet?
Open Office base just doesn't quite manage it. It either needs an ODBC driver or uses its own wierd database. I really want to work with existing sqlite databases.
If you knocked up a simple database and then switched into data edit mode, I'm sure it'd work.
There ain't nothing with a 'data edit mode', that's the trouble. Well, not quite true, but the major, well maintained, database management programs like sqliteman have a maze of menus to negotiate to get to edit the databse and, once there, the editing is clumsy.
I want to be able to design something that allows me to simply run a command (menu or coomand line) which will open up a window with my database table ready to edit.