Difference between revisions of "Database: SQL-Editor"

From Wiki - Heidler Strichcode GmbH
Jump to navigation Jump to search
Line 1: Line 1:
'''<span style="font-size:xx-large;">[[File:Gefahr.jpg|left|Hinweis auf eine Gefahr]]</span>'''
'''<span style="font-size:xx-large;">[[File:Gefahr.jpg|left|Hinweis auf eine Gefahr]]</span>'''

Revision as of 08:13, 29 July 2021

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..