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


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.

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 further processed. After creating the query we recommend to follow the instructions.
    Warning:
    An SQL query can only be SELECT and it cannot contain the ORDER BY clause.
    Ordering (and other edits) are subsequently 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.