SQL queries

You can define stand-alone SQL queries to extract information from the database and present this information in a report or chart. These stand-alone queries are not embedded in any other software component and are executed independently.

Stand-alone queries can only read data from the database. A stand-alone query cannot add, delete, or update records in the database.

Hinweis

You can also create queries in 4GL scripts or libraries. These queries can read and update data in the database. See Infor10 ERP Enterprise Development Tools Development Guide (U8883 US).

You can create stand-alone queries with Easy SQL or with the Text Manager. Easy SQL helps users to define queries in a simple, menu-driven way. Text Manager enables you to create more complex queries.

You can execute stand-alone queries in the following ways:

  • Through the Query Data (ttadv3580m000) session.
  • Through the Execute Query (ttadv3280m000) session.
  • From a menu. You must first add the query, as a menu field of type "Query", to a menu.

Verwandte Themen