4. Custom SQL

fmCustomSqlsfmStringDialogfmCustomSqlInsertParamDialogfmCustomSqlFillParamDialogfmMySQLHelp

The "Custom SQL" section of Store Manager allows to operate your store database using the created SQL commands.

To launch this section open the Tool tab of Store Manager top menu and select [Custom SQL]:

The right pane of Custom SQL has three tabs: Edit, Results and Logs.

Custom SQL section

If you have generated SQL statement, contained in a separate file, you can download it by using the corresponding button on the toolbar:

Load query from file

To create a new SQL Query press the corresponding button and specify the new query name in the creation form. Click the [OK] button to save your entries. Then, you can launch the Visual Query Builder to facilitate the queries creation, or manually set the query in the top area of the "Edit" tab. When your query is completed, do not forget to press [Save].

Run Visual query Builder
Execute SQL button

< - The [Execute SQL (F9)] button can be used to check the correctness of the specified query.

The results will display on a same-named tab of this section:

Results tab

You can check the logs tab, if any errors occur during executing:

Logs tab

To rename already existing SQL statement, press the [Rename] button and type the new "SQL Name."

Rename SQL

Click the [OK] button to save changes.

Delete button

[Delete] removes unused SQLs from the available list.

[SQL Help] ensures the provision of detailed information regarding formation of SQL queries by using the embedded templates.

SQL Help button

For example, you need to create a query by combining certain strings of database. To do this, you should use a CONCAT function- click the [SQL Help] button and find among the folder list with the request functions the necessary one:

In our case, this is a Functions - > String Functions - > CONCAT

In the right pane of the "SQL Help" window, the "Description" field contains information about this type of SQL query. There is also a link at which you can find more detailed information about CONCAT query. In the lower right pane, examples of CONCAT function application are submitted.

CONCAT function

This will help you to compose a correct SQL request. To verify the query press the corresponding button in the "Custom SQL" top toolbar that will launch the check editor.

Linked to... button

< - You can link the created SQL query to the products of the store database or select simple type from the drop-down.