Interview question and answer for Data dictionary in MSD Axapta

Table - collection of rows and columns

EDT(Extended datatype) - Inheritance, code easy readability, lookups,- 2 RELAtions [Normal and RFF [where clause]

example : select * from custtable - is normal

select * from custtable where gender == female is RFF

How to add columns to the Lookups [Index, Titlefield1, 2 or autolookups]

Q) How to get lookups??

In 3 ways

- EDT, AutoLookup,Relations

Q) what is base enum???

Set of literals or constants which will never change

- example [week - s,s,m,t,....] enums are stored as integers and max - 250

can be accessed by using :: [scope resolution]

Indexes

why do we use index ?- faster performance in select queries
Not to allow duplicates
FieldName Followed by Idx = AccountNoIdx
Field groups:
Autoreport - ctrl + p
Autolookup
almost all the fields should fall under a fieldgroup - on the forms - field groups will form as Group control

Relations on table :
How one table is related or linked to another
Normal - CustTable.accno == custTrans.accno
RFF - paid == custTrans.paid [secondary table on enums]
FF - custTable.gender == male [primary table on enums]

Methods on table:


initvalue(),validatefield(),validatewrite(),modifiedfield(),validatedelete(),delete(),update(),insert()

forcible inserts/delete/updates
dodelete()
doinsert()
doupdate()


Macros:      macros are reusable components,  macros will reduce lines of code
pre-processor
no debugging
faster as they are already compiled
3 ways  - local macro, aot-,macro library
can we pass values to macro ? yes