How many kind of lookups can be made and how.

When the recid is generated, what is its utility?

when the record is entered in the table the recid is generated by the kernel.it is unique for each table.

Difference between Primary & Cluster index.

Primary index: It works on unique indexes. The data should be unique and not null. Retrieve data from the database.

Clustered Index: It works on unique and non unique indexes. retrieve data from the AOS.

The advantages of having a cluster index are as follows:

• Search results are quicker when records are retrieved by the cluster index,
• especially if records are retrieved sequentially along the index.
• Other indexes that use fields that are a part of the cluster index might use less data space.
• Fewer files in the database; data is clustered in the same file as the clustering index. This reduces the space used on the disk and in the cache.
• The disadvantages of having a cluster index are as follows: Olt takes longer to update records (but only when the fields in the clustering index are changed).
• More data space might be used for other indexes that use fields that are not part of the cluster index if the clustering index is wider than approximately 20 characters).

What is the function of super()

This method calls the system methods to execute. It is used to instantiating the variables at the parent class. Used for code redundancy.

How many kind of lookups can be made and how.

By using table relations Using EDT relations.

Using morphx and using X++ code(Syslookup class).

How many types of Delete Actions are there in Standard Ax and define the use of each

None

Cascade

Restricted

Cascade+Restricted.

What are the different types of Table groups defined on table properties?

• Miscellaneous
• Parameter
• Group
• Main
• Transaction
• WorkSheetHeader
• WorkSheetLine

Multiple inheritance possible or not, if not how can we overcome that.

In X++, a new class can only extend one other class; multiple inheritance is not supported. If you extend a class, it inherits all the methods and variables in the parent class (the superclass).

We can use Interfaces instead of multiple inheritance in Ax

What is the utility of the RunOn property

Application objects such as reports, tables, and methods can run on the application object server (AOS) or the client. An object can also have the RunOn property value set to Called from. Objects set to Called from can run from either the client or server, depending on where the object is called from. This topic describes the Run On property, tiers that class objects can run on, and hints about using AOSRun Mode.

Default value of RunOn for Classes

Called from Menultems Client

What is difference between new & construct method

new(): used to create a memory to the object.

Construct(): You should create a static construct method for each class. The method should return an instance of the class.

What is the difference between form init() & DS init()

Form init(): init is activated immediately after new and creates the run-time image of the form.

DS init(): Creates a data source query based on the data source properties. The form data source init method creates the query to fetch data from the database and sets up links if the form is linked to another form.

When a form opens what are the sequential methods called.

Form init(), DataSource init(), Form run(), DataSource executeQuery(), canClose(), close().

Where is the best place to write code to perform filter in a form

FormDataSource - executeQuery() and call this method in the design field of the form.

What are the different types of menu items available, explain each of them

• Display - for Form
• Output - for Report
• Action - for classes

What are the most important methods on the Report?

• Init()
• run()
• fetch()
• send()
• print()

How can we sort the DS, what facility we can get in by placing fields in Ranges

this.query().datasource(1).addsortfield (fieldnum(tablename,fieldname),sorti ng:ascending);