Table
Relations
· Normal to specify relation fields without conditions.
· Field Fixed to specify relation fields to restrict the records in the
primary table.
· Related
Field Fixed to specify relation fields that restrict the records in the
related table.
1. For Normal, enter the following in
the Field Relation property pages:
· In the Field property, select the field in the
primary table that relates to a field in the related table.
· In the Related Field property, select the field in the
related table.
2. For Field Fixed, enter the
following in the Field
Relation property pages:
· In the Field property, select the field in the
primary table to use to restrict the records.
· In the Value property, enter the value of the
selected field as the filter. This relates only records in the primary table
that match that field value. Only numeric values can be entered in the Valueproperty. Field fixed
relations can be created only on numeric fields.
Each of the
related fields are ANDed
in the table relation.
3. For Related Field Fixed, enter the
following in the Field
Relation property pages:
· In the Value property, enter the filter value of
the selected field. This causes only records in the related table that match
that field value to be related. Only numeric values can be entered in theValue property. Related field fixed
relations can be created only on numeric fields.
· In the Field property, select the field in the
related table to restrict the records.
Each of the
related fields are ANDed
in the table relation.
overview of how to use the index hint
and order by keywords in
select statements.
TO
|
USE
|
select .. where ...
|
|
select .. order by ...
where ...
|
|
Select records and force a specific index to be used. |
select .. index hint ...
where ...
|
Select records where the order is significant and force a specific index to be used. |
select .. index hint ...
order by ...
where ...
|
Indexes in
ax
The
advantages of indexes are as follows:
· Their use
in queries usually results in much better performance.
· They make
it possible to quickly retrieve (fetch) data.
· They can be
used for sorting. A post-fetch-sort operation can be eliminated.
· Unique
indexes guarantee uniquely identifiable records in the database.
The
disadvantages of indexes are as follows:
· They
decrease performance on inserts, updates, and deletes.
· They take
up space (this increases with the number of fields used and the length of the
fields).
· Some
databases will monocase values in fields that are indexed.
what is the difference
between index and indexhint in select statement.
While fetching data
from the database we use select statement and for better performance in data
fetching we use an index/indexhint.
Index: when we use index in select
statement it implies that the declare index field should behave as an order by
and it is optional for the database to use. Database can use its own
preference.
Index hint: it force the DB to use
that index for fetch the data whether it is right choice or not.
Differences
between MorphX and Intellimorph
MorphX
is the Microsoft Dynamics AX IDE( Integrated Development Environment) which
includes:
- Data Dictionary
- Tools for creating menus, forms and reports for Windows- and Web
clients
- Compiler and debugger for the object oriented programming language X++
- Version control system
- Label (multi language text) systems
IntelliMorph is the Runtime Environment embedded in Microsoft Dynamics AX, that
draws menus, forms, and reports for Windows- and Web-clients with the correct
contents, size, and layout according to:
- The language your texts are displayed in.
- What features you can access.
- How wide you want the fields on your installation.
- The formats you are using for dates and numbers.
Abstract methods in ax 2012
Abstract methods are used when you wish to force the developer of a
sub-class to override the method and provide functionality.
Methods are
declared as abstract by using the abstract keyword,
for
example "
public abstract void abstractMethod()
{
}
No code or
declarations are allowed inside an abstract method.
· It is not
possible to declare a method as abstract unless the class is also declared as
abstract.
· If a
sub-class is created which does not override the abstract methods in its
parent, then a compile error will occur where that sub-class is used.
Difference
between In Memory and Tempdb
In Memory
Tempdb
1. Holds data temporarily in client or
1. Holds data temporarily in database
server
2. These tables can't store in the database 2.These tables
can store in the database.
.
3. Can't apply security.
3. Can apply security.
Lookups in ax
Lookups are used in Axapta to show the user a list of possible
values from which to select, whilst entering data into a control on a form.
Axapta has
extensive support for automatic lookups, as well as the capability to manual
enhance or replace the automatic system.
The standard lookup for customer accounts
Introduction
The standard lookup system in Axapta is based on the use of
table field or data type relations. These specify a link between a particular
data type, or particular table field, and a corrsponding field in another table
containing the base (reference) data.
For example, in the standard application, the CustAccount EDT
has a relation specified to CustTable.CustAccount. This means that any table
field using the CustAccount EDT will be automatically given a lookup icon which
allows the user to select from the list of accounts in CustTable.
It is
possible to further restrict the values which will appear in the lookup by
specifying a "Related fixed field" relations on the datatype. In this case, only those values satisfying the
relation will be shown in the lookup. See the Dimension datatype for an example
of this (each Array Element has it's own relation defined
Informative blog and it was up to the point describing the information very effectively. Thanks to blog author for wonderful and informative post...
ReplyDeleteMS Dynamics Online Training