formDataSource formDataSource; formRun formRun; salesTable salesTable; int i; // Change data in calling datasource if(element.args() && element.args().caller() && element.args().caller().handle() == className2Id('formRun')) { formRun = element.args().caller(); for (i = 0; i <= formRun.dataSourceCount(); i++) { formDataSource = formRun.datasource(i); if (formDataSource && formDataSource.table() == tablenum(salesTable)) // Search for specific table { salesTable = formDataSource.cursor(); break; } } … Continua a leggere AX – D365FO – Change data in calling datasource
Categoria: Data source
AX – D365FO – Refresh grid data with Command Button
To refresh grid data of a Form grid just create a Command Button and set Command Property to Refresh Obviously the button must be created under a Group button object and this under an Action Pane which contains the data source that must be refreshed.
AX – D365FO – Detect selected line (row) changed in FormGridControl
To detect selected line just use form data sources. Override active() method of the date source - it's executed when a user switches to another record. The active record is in the automatic variable with same name as the data source. Here is an example public int active() { int ret; ret = super(); if (ret) { … Continua a leggere AX – D365FO – Detect selected line (row) changed in FormGridControl
AX – D365FO – Mark a form grid record with checkbox
This example mark all records of a form grid record looping throught the data source public void selectall(boolean _select) { CompanyInfo localCompanyInfo; localCompanyInfo = companyInfo_ds.getFirst(); while(localCompanyInfo) { this.findRecord(localCompanyInfo); this.mark(_select); localCompanyInfo = companyInfo_ds.getNext(); } }
AX – D365FO – Loop through record from data source
/////////////////////////////////////////////// Using a while loop SalesLine localSalesLine; localSalesLine = salesLine_ds.getFirst(true) as SalesLine; if (localSalesLine) { while (localSalesLine) { //Do your thing localSalesLine = salesLine_ds.getNext() as SalesLine; } } /////////////////////////////////////////////// Using a for loop SalesLine localSalesLine; for (localSalesLine = salesLine_ds.getFirst(true) ? salesLine_ds.getFirst(true) : salesLine_ds.cursor(); localSalesLine; localSalesLine = salesLine_ds.getNext()) { //Do your thing }
AX – D365FO – Get source record from a caller object
In this example I'll show how to obtain the source record from a caller object. Suppose you have a form A that calls form B. In Form B you want to know what is the data source of the Form A and if it's a VendTable you want to retrieve the AccountNum field VendTable vendTableLocal; … Continua a leggere AX – D365FO – Get source record from a caller object
AX – D365FO – Get DataSource name of a caller object
Suppose you have a form A that calls form B. In Form B you want to know what is the data source of the Form A and do something..... This is the code to obtain the data source name of a caller object (such as Form, menu item, etc..). args.record().dataSource().Name();
AX – D365FO – Clear data source query ranges
If you add a query range with a certain value to a Query, then next time you execute the query with another value the query doesn't clear previous range. In order to clean the old values you have to use clearRanges() method see example below /// </summary> public void executeQuery() { super(); QueryBuildDataSource productCategory_ds = … Continua a leggere AX – D365FO – Clear data source query ranges
D365FFO – AX – X++ – Refresh DataSource and retain position
Refresh a DataSource is a very common task to Dynamics AX developers, as you'll most likely perform changes on a record and have to present it to the user, on a form. The most commonly used method to refresh the DataSource to make a form show what you have changed on a record is the research method.The … Continua a leggere D365FFO – AX – X++ – Refresh DataSource and retain position
D365FO – AX – X++ – Tutorial: refresh, reread, research, executeQuery – which one to use?
X++ developers seem to be having a lot of trouble with these 4 datasource methods, no matter how senior they are in AX.So I decided to make a small hands-on tutorial, demonstrating the common usage scenario for each of the methods. I have ordered the methods based on the impact on the rows being displayed … Continua a leggere D365FO – AX – X++ – Tutorial: refresh, reread, research, executeQuery – which one to use?
