The expert user tool shows system information, contains maintenance tools, and offers a direct connection to the database
The system information dialog shows how many items are in the database per module, the database name, and the driver that is used to connect to the database
For now there is only one maintenance tool available, "compact database and
shutdown". This is a direct call to the HSQL database engine.
Information on this tool from the HSQL database website:
"Writes out a new .script file which contains the data for all the tables,
including CACHED and TEXT tables. It then deletes the existing text table
files and the .data file before rewriting them. After this, it backs up the
.data file in the same way as normal SHUTDOWN. This operation shrinks
all files to the minimum size"
The SQL tool offers a quick and direct way to manipulate data in the database. It overrides all checks on data so it should be handled with care.
If you're not familiar with SQL, you'd be better off not using the SQL Tool
as you might make unwanted changes.
Creating and executing a sql statement
Enter a SQL statement in the "query input" field and press "Run" to execute
the statement. Errors will be shown if the query was incorrect
(these messages are not generated by Data Crow but by the database engine).
Previously executed statements can be retrieved from the "Prepared SQL statements" list box. You will see that a couple of predefined queries are already in there.
The result of a select query is shown in the "Query result" table