Skip Navigation LinksALVAO 11.2Application pagesOther appsAlvao Asset Management ConsoleToolsDatabaseSQL queryQuery Skip Navigation Links.


Skip Navigation LinksALVAO 11.2 / Application pages / Other apps / Alvao Asset Management Console / Tools / Database / SQL query / Query

Query

In this window you can create a new or edit the current SQL query (SELECT).

Options:

  • Input field - type SQL query and select OK to run the query.
  • To cancel all changes made to the query, select Storno
Note:
The SQL query must be of SELECT type only and must not contain an ORDER BY clause. Sorting (and other modifications) is then done in table. INSERT, UPDATE and DELETE clauses are not supported by this function. They are supported by Run SQL script.

 

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