Hi Graham, >> You don't need to create special tables for data entry. You can create views >> instead, coupled with "instead of" triggers. > >> I'll see if I can put together some SQL with a few examples of how a view >> updates several >related tables. > > As the OP, I would be very interested in this.
OK, I'll put something together and post it here. Do you have a schema you've been working on? I might be able to adapt it for you. > I did try using Views, as there is no forms option in SQLiteManager Try clicking the pencil button to show "Record Editor". I could only get it to work sometimes for views. > but the "add" button is > greyed out when using a View. SQLiteManager seems to support updates (changing of existing rows) but not inserts (adding a new row) in views. >> Comparison of SQLite GUI tools: >> http://www.barefeetware.com/sqlite/compare/?ml > > This link is currently giving an internal server error. Ah, thanks for the heads up. I've been moving my website to another hosting service. They don't seem to like some permissions on the PHP files. Incidentally, this page is actually a PHP file that grabs the data from an SQLite database. This database provides a view for the PHP to read and for a data entry operator (well, that's most often me) to read when using a GUI. That same view has "instead of" triggers so I can enter changes back into that same view, which propagates back to the underlying tables. One of the features compared on the SQLite GUI comparison web page (which is now publicly viewable again), is "Data Entry -> Entry in views (with "instead of" triggers)". This will tell you what SQLite GUI editors I found that support editing of data in views. Until today, I hadn't updated this comparison matrix for over a year, and now realise that some apps have even disappeared. It needs updating. If anyone is familiar with another SQLite GUI editor, please provide values for the comparison table and I will add it to the web page. Or let me know of any changes needed to existing data, or extra features you've compared. Tom BareFeetWare -- Comparison of SQLite GUI tools: http://www.barefeetware.com/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
