F9 should initiate the same action as the Verify Query button for a written SQL query in Query Design view, SQL mode, but this does not occur. Reproducible: Always Steps to Reproduce: 1. Open a Query in Design view 2. Make a change to the SQL query to render it invalid 3. Press F9 4. Click the 'Check Query' icon Actual Results: Checking the SQL query using the F9 shortcut produces no output. Clicking the 'Check Query' icon produces the message 'The Query is incorrect'. Expected Results: That the F9 shortcut would act the same as the 'Check Query' icon. This shortcut is not shown on the right-click menu The earlier list of shortcuts shows this as functional under the Data view which is surely incorrect because you cannot move into Data mode from an incorrect SQL query.
It's a conflict with Kate's (part) shortcut for "Show folding markers" action. One solution could be to change to something else. MS Access lacks the action; users have to actually switch to data mode to check validity. The closest thing I (quickly) found is MS SQL Server's Query Analyzer Shortcuts offer CTRL+F5 for "Parse query and check syntax": http://blog.sqlauthority.com/2007/01/20/sql-server-query-analyzer-shortcuts/ Would it be OK to change?
Git commit 1ba3fd5a5bcff842ec27ee27e65cc1808eb0dd71 by Roman Shtemberko. Committed on 19/01/2015 at 09:25. Pushed by rshtemberko into branch 'calligra/2.9'. Add Ctrl+F5 shortcut for Check Query of SQL query in Query Design view SQL. REVIEW:122051 M +2 -1 kexi/plugins/queries/kexiquerydesignersql.cpp http://commits.kde.org/calligra/1ba3fd5a5bcff842ec27ee27e65cc1808eb0dd71