On Fri, Feb 05, 2016 at 08:22:07PM +0000, steve-ALUG@hst.me.uk wrote:
On 05/02/16 17:05, Chris Green wrote:
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.
Back in the day, on Windows, if M$ access wasn't an option, I'd use some sort of visual programming language, a database, and a grid control - either native to the programming language or proprietary. I expect there's equivalents in the open source world, but I don't know where/how. Good luck.
There isn't much, that's the trouble. There's Gambas which is a VB lookalike and is a possible way to get what I want.
My best shot so far is to use Gnome-DB which is where libgda is developed. It's pretty high level so a C/C++ program to produce a window, form with a grid, etc. is only a hundred lines or so. I can do C/C++ so it's not entirely out of the question. There's a Python wrapper for libgda too but it's a bit under-documented.