RAZORSQL The latest RazorSQL update - 4.1.5 - addresses several things from your review: 1. Unaware of SQLite rowid field The edit table tool now displays the rowid field for SQLite. 2. Editing via the edit table tool requires several clicks The edit table tool is now automatically editable on tab, shift-tab, click, etc. Clicking is no longer required to edit. 3. After selecting a table and hitting edit, asked to re-select table I believe you are referring to selecting a table from the database navigator on the left-hand side of the screen. If you use the context menu for the database navigator, you will be taken directly to the edit table tool. If you use the main Tools Edit Table menu, you will be shown a list of tables to choose from. To determine which table to populate in the dropdown, RazorSQL first checks any highlighted text in the SQL editor to see if it is a table, and now this version also checks any selected tables in the navigator if there are no highlighted tables in the SQL editor. 4. RazorSQL showing SQLite null values as <NULL> This problem has been addressed 5. Edit table tools enters integers as text RazorSQL does check the field type to determine whether or not to wrap it in single quotes, etc. This problem may have been caused because you were editing a view. RazorSQL no longer allows users to bring up the edit table tool for views in SQLite since SQLite views are read-only. 6. Showing nulls in the edit table tool RazorSQL does show null values as null in the edit table tool as it is important to many users to distinguish between null values and empty values, i.e. ''. Previous versions were incorrectly displaying null values in SQLite, and this problem has been addressed. (Version 4.1.5) |