Database: SQL-Editor

From Wiki - Heidler Strichcode GmbH
Revision as of 17:27, 10 March 2020 by Mnh (talk | contribs)
Jump to navigation Jump to search
Hinweis auf eine Gefahr


You should use this menue only after consulting the Heidler Support-Team
Changes you will do here will be stored in the HVS32 Database directly, without any checks.
This means you can destroy your database and cause data loss!

Menu: database > Sql-editor

Within the SQL-Editor you can directly send SQL statements to the HVS32 database.

Ansicht des SQL-Editors

In the upper textfield you are able to write a SQL Statement/Select Query. By clicking the green check icon you will execute the sql instruction.

You will see the results in the lower textfield only when you activate the checkbox "select Ergebnis anzeigen".

With the left handed buttons you are able to clear the entered statement or to save / open a sql file.

The Button ">> CSV" gives the ability to export/save the result of your sql query to a csv file.

Info: If you make "Updates", those are not saved until you make a "Commit" with the red check button, or otherwhise you can activate the checkbox "commit after execute" so it will be done automatically..