To run a database query
-
Start the SQL Editor in the Designer by selecting the Database > Run SQL Editor menu item.
-
Enter your database query in SQLite notation in the query window. The editor supports highlighting.
-
Run the database query using F5.
The result are displayed in the results window.
TIP: To sort by a specific column, click on that column in the table header.
TIP: Use Ctrl + C to copy the individual entries or lines to the clipboard. Select Shift + Select or Ctrl + select to select multiple lines in the table.