Skip Navigation LinksALVAO 8.2Index of Windows and CommandsALVAO Asset Management ConsoleToolsDatabaseSQL Query Skip Navigation Links. Skip Navigation Links Skip Navigation Links.


Change ALVAO version
Change language

SQL Query

The window displays a table with the SQL query results. You can use the buttons in the toolbar on the top to:

  • enter a new SQL query and view the results.
  • open an existing SQL query stored on the hard drive.
  • save the SQL query to a file on the hard drive.
  • edit the SQL query that is currently open.
  • use output features – print the results table, analyze the table in MS Excel etc.
Warning:
SQL query has to be only SELECT and it could not contain the ORDER BY clause.
Ordering (and other edits) are consequently performed in grid.
INSERT, UPDATE, and DELETE are not supported by this function. They are supported by the Run SQL script function.
Note:
After creating the query we recommend to follow the instructions.

 

Did not find what you were looking for? Ask our technical support team.