SQL Support

vsTASKER allows capability to define SQL tables and connect to a mySQL or MariaDB database/schema (local or remote) either to retrieve data or to store results.

In mySQL, physically, a schema is synonymous with a database. You can substitute the keyword SCHEMA instead of DATABASE in SQL syntax.

Some other database products draw a distinction. For example, in the Oracle Database product, a schema represents only a part of a database: the tables and other objects owned by a single user.

From the SQL environment, user can define simple tables and columns.

vsTASKER will generate all necessary code to facilitate the access of the data and the connection to the SQL database.

Connection to Server

Once in the SQL environment, right click the mouse button and select Properties.

You will get the following window:

Select the server MariaDB. The generated code will adapt to the choice and will use default configuration settings. For more information on the use of the supported SQL server, refer to the Tutorial.

Popup Menu

Outside an SQL schema:

Edit Connection: setup the access to the SQL server. See here.

Add Schema: create a new schema to store Tables. Normally, only SQL schema must be enabled at a same time, all others must be disabled.

Select All: select all defined SQL schemas (useful for removal)

Inside an SQL schema:

Properties: SQL schema setup.

Add Table: add a new Table into the SQL schema. See here.

Select All: select all defined Tables (useful for removal)

Refer to the Tutorial to learn how to develop your first SQL simulation.

Contents of SQL Support

Schema

Table

Column

SQL Support

Connection to Server

Popup Menu

Contents of SQL Support