Skip Navigation LinksALVAO 8.2ALVAO Asset ManagementSearching for DataSQL Query and Script to Database Skip Navigation Links. Skip Navigation Links Skip Navigation Links.


Change ALVAO version
Change language

SQL Query and Script to Database

This method is intended to recover data that cannot be read from the database with any other method (queries, search), and to work with data in the database respectively.

In the Tools – Database menu there are two options for accessing the database using SQL:

  • Run SQL script – allows to run any SQL script, but the result is only the information about the script execution status (executed successfully/unsuccessfully).
    Warning:
    If you are working with diacritics, SQL has to be in UNICODE, otherwise the diacritics will be processed incorrectly and the script will not execute properly.
  • SQL query... – allows to run only SELECT query, but the result can be displayed in grid and work with it further. After creating the query we recommend to follow the instructions.
    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, DELETE or MERGE can be executed using the SQL script.

Note:
To write an SQL query, you will need at least basic knowledge of the ALVAO Asset Management database structure. You can also contact ALVAO Technical Support for assistance.

 

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