Research and Execute query difference:

Research and Execute query difference:
When you call the DatasourceName_ds.Research () it will by default execute the Form data source related query and code written in execute query.
When we call the DatasourceName_ds.executequery() it will by default execute the Form data source related query and code written in execute query plus it will consider the query range value ,query related any changes done in any calling place.

Example:
In research it will not consider the range value written in clicked method.
In Execute query it will consider the range value.

Basic Business Process flow diagram.

Some basic inventory concept.

Tare weight : It is the weight of the empty curtain or roops or goods protector which are used while transporting/storing one item.
In Ax you can specify the parameter value for a specific item by going
Inventory>Item Details>setup>Item Data>
Gross weight = Net weight + Tare weight.
External item number:
This concept is used when a item is identified by our system(Ax application) different name other than the Customer/vendor given name.
Inventory>Item Details> setup button>Customer Details Description/Vendor Details Description.

Barcode:Inventory>item Details>Setup button>Barecode.
Example
suppose we have different color,size,configuration of Dell laptops in our inventory.
1.17inch LCD black ,i3 processor inspiron 2.15.4 inch LCD blue ,i5 processor inspiron.3.13inch LCD RED,i7 processor inspiron.
We will enter a single item entry in the inventory and create multiple barcodes based on the models available.
This barecodes are used to identify a speicfic configuration,size,color item correctly.

what is basic 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.

Install Ax4.0 and Ax2009 in Windows XP.

To install Ax4.0 and Ax5.0 follow the below steps.

1. .net framework 2.0 install.

2.windows installer3.1 install.

3.install .net framework 3.5.

4.install sql server 2005 sql server database services.

5.install the sp2 patch layer.(if u install ax2009 ,for ax4.0 it is not necessary).

6.change the active computer name and add environment variable one more
component UserDnsDomain value any thing.

7.install Ax 2009 application.

8.Create a new Data base instance with that active computer name.

9.it will successfully install all the components.

10.restore the changes done in step :6.

11.Go to the server configuration utility and change the database name to local computer name.

12.go to the client configuration utility and change the connecting instance computer name.

13.go to the services.msc and start the service.

14.upload the license and the data in the checklist.

For any details information please contact me,I will get back to you.

Issue

Hi guys,if u r facing any issue regarding Ax technical /functional please post your problem.
We will try to help it out.