Creating and Running a Query
Quickly write, run, and save queries with Arctype's powerful SQL editor
Queries allow you to display or modify data from databases. Because your components are powered by queries, your internal applications can read and write data to databases as well.
You can connect components to queries by their properties. For instance, you can set a slider to update the value of a row in your database to the number of the slider.
- Click the
+button on the top-left. - Then chose
New Query.
To execute a query, write SQL in the SQL Editor and then either click
RUN or use the shortcut cmd + EnterTo write and execute multiple queries, separate them with a semicolon.
To execute a single query among many in the same editor, highlight the query you want to run and click
RUN. The rest of your editor will be ignored, and only the highlighted section with be executed.Notice the Result View directly below the SQL Editor displays the results.Click on the query name (if not previously named, your query should be called
Untitled Query) to change it. Save your changes by pressing enter or clicking the Save button.