Creating and Running a Query

Search…

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.
Creating a Query
Click the + button on the top-left. 
Then chose New Query. 
Executing a Query
To execute a query, write SQL in the SQL Editor and then either click RUN or use the shortcut cmd + Enter
To 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.
Saving a Query
​

Getting Started - Previous

Connecting to a Database

Next - Getting Started

Filtering and Sorting Tables

Last modified 20d ago

Copy link

Contents

Creating a Query

Executing a Query

Saving a Query