My favorites | Sign in
Project Home Downloads Wiki Issues Source
New issue   Search
  Advanced search   Search tips   Subscriptions
Issue 195: 'Execute SQL' tab: Display the number of rows updated/deleted in the status bar
4 people starred this issue and may be notified of changes. Back to list
Status:  Accepted

Sign in to add a comment
Project Member Reported by, Oct 24, 2008
Reported by Simon Speich (on mozilla.extension.sqlitemanager group):

In the 'Execute SQL' tab it would be useful to give the user feedback after
doing an UPDATE, DELETE. Instead of displaying the status 'Number of rows
returned: 0' display 'Number of records updated/deleted: '.

Oct 24, 2008
Project Member #1
If you set Pragma count_changes = 1 (using sql or in db settings) then the number of
rows updated or deleted is displayed in the output area.
Perhaps we need an option to enable count_changes by default because it gets set to
off every time a new connection is made to a db.
Sign in to add a comment

Powered by Google Project Hosting