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.