Query
A statement that fetches a number of records from database based on the conditions provided is called a Query. Two types of queries used in Javra IDE are:
- Main Query : Associated with main buffer of any maintenance program
- General Query: Associated with widgets/lookups.
The main query will always be there for the selected table using which the maintenance program is created. The list of queries available in a program can be viewed by clicking on the Query tab available in the Right Panel. A query in Javra IDE facilitates the users to:
- Make a particular query as the main query, for a selected program.
- Define both internal and external tables associated with this program.
- Provide a way to write a query in a query clause text-field.
- Check for the query syntax.
Figure below shows the Query section of program ‘c/custmord.p’ which has a main query named ‘Customer’ and other two queries ‘Salesrep’ and ‘state’ associated with its widgets: SalesRep (lookup field) and State (combo-box) respectively.
