Hello Rob Richardson, >The only tool I have for examining and manipulating SQLite databases is >SQLiteSpy. If I want to change data in that program, I have to write an >SQL statement. Every other database editor I've seen lets a use do >simple things from a grid.
As the author of SQLiteSpy: There are indeed DB managers which _allow_ cell editing for all SQL SELECTs. Some are able to commit changes to single table SELECTs. However, I have experienced frequent failure updating multiple table, nested, and aggregate SELECTs. There are reason why such updates must indeed fail: The SQLite library lacks certain API required to implement cell editing: Most notably, there is no functionality to retrieve the exact origin (table, row and column) of a cell, which must be known to store back the modified value. These issues have been discussed and acknowledged on this list. I am hopeful that we will eventually see them implemented. Until then, however, there are theoretical limits to grid editing. They could be worked around by parsing the SQL, but this would be overkill for a simple DB editor like SQLiteSpy. I therefore decided to disable cell editing altogether in the first version of SQLiteSpy. > Open a table and data is loaded into a grid, >click on a cell and type in a value and it gets written to the table, >select a row and click a Delete button and the row is deleted from the >table, and so on. There must be a tool somewhere that will do that for >a SQLite database, or there's some feature of SQLiteSpy I don't know >about. Can somebody please point me to one or the other? The upcoming version of SQLiteSpy will see support for table cell editing: The grid will internally work in table mode for tables selected from the schema treeview. Such table SELECTs will be editable, use an improved buffer mechanism, execute faster, and use less memory. Result sets from queries executed from the SQL editor will be read-only, even if they are just simple table selects. I hope to release within the next few days. Regards, Ralf ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
