Skip to main content

Show field of run time control in MSD axapta


 public void showFields(tableId tableId,FormGridControl formGridControl1, FormBuildDataSource formDataSource1)  
 {  
 FormStringControl formStringControl1,formStringControl2;  
 DictTable dictTable;  
 DictTable dictTable1;  
 DictTable dictTable2;  
 fieldId fieldId;  
 int i;  
 int t;  
 int fieldCnt;  
 Query Q1;  
 str ColValue[];  
 str strQuery;  
 object formRunCaller;  
 ;  
 formRunCaller = element.args().caller();  
 testId1=formRunCaller.MethodA();  
 dictTable1 = new DictTable(_TestColumn.TableId);  
 // dictTable2 = new DictTable(_TestRows.TableId);  
 dictTable = new DictTable(tableId);  
 select * from _TestColumn where _TestColumn.QId == _Question.QId && _TestColumn.TestId==testId1 ;  
 if(_TestColumn)  
 {  
 ColValue[1] = _TestColumn.Col1;  
 ColValue[2] = _TestColumn.Col2;  
 ColValue[3] = _TestColumn.Col3;  
 ColValue[4] = _TestColumn.Col4;  
 ColValue[5] = _TestColumn.Col5;  
 ColValue[6] = _TestColumn.Col6;  
 ColValue[7] = _TestColumn.Col7;  
 ColValue[8] = _TestColumn.Col8;  
 ColValue[9] = _TestColumn.Col9;  
 ColValue[10] = _TestColumn.Col10;  
 //ss  
 ColValue[11]=_TestColumn.Col11;  
 ColValue[12]=_TestColumn.Col12;  
 ColValue[13]=_TestColumn.Col13;  
 ColValue[14]=_TestColumn.Col14;  
 ColValue[15]=_TestColumn.Col15;  
 ColValue[16]=_TestColumn.Col16;  
 //ss  
 }  
 for (i=1; i<=16; i++) { if(ColValue[i] != "")  
 {  
  fieldId = dictTable.fieldCnt2Id(i);  
 formStringControl1 = formGridControl1.addDataField(formDataSource1.id() ,fieldId2Ext(fieldId, 1));  
 formStringControl1.label(ColValue[i]);  
 }  
 else  
  {  
 continue;  
 }  
  }  
 //formGridControl1.dataSource(_TestRows); }  

Popular posts from this blog

strScan and Find a first occurrence of a string in a string using x++

strScan (Find a first occurrence of a string in a string) info("int strScan(str _text1,str _text2,int _position,int _number)"); info("Searches a text string for the occurrence of another string."); info("_text1 - The text string to search."); info("_text2 - The string to find."); info("_position - The position at which the search should start."); info("_number - The number of characters that should be searched."); info(int2str(strScan("ABCDEFGHIJ","DE",1,10)));

Code to get customer Primary Address in Ax 2012

Below Code to get customer Primary Address in Ax 2012. CustTable custTable_P; DirPartyTable dirPartyTable_P; DirPartyLocation dirPartyLocation_P; DirPartyLocationRole dirPartyLocationRole_P; LogisticsLocation logisticsLocation_P; LogisticsLocationRole logisticsLocationRole_P; LogisticsPostalAddress logisticsPostalAddress_P; LogisticsPostalAddress primaryAddress_P; while select custTable_P where custTable_P.AccountNum =='ED_01029' join dirPartyTable_P where dirPartyTable_P.RecId == custTable_P.Party join dirPartyLocation_P where dirPartyLocation_P.Party == custTable_P.Party && dirPartyLocation_P.IsPrimary==NoYes::Yes join dirPartyLocationRole_P where dirPartyLocationRole_P.PartyLocation == dirPartyLocation_P.RecId join logisticsLocationRole_P where logisticsLocationRole_P.RecId == dirPartyLocationRole

Get record from table on the basis of field id in Microsoft dynamics axapta x++

How to Get record from table on the basis of field id in dynamics axapta x++. just try following code in job to understand better way. emplTable emplTable; FieldId fieldId; ; fieldId = fieldNum(emplTable, Emplid); select emplTable; info(emplTable.(fieldId)); select emplTable where emplTable.(fieldId) == '1101'; info(emplTable.Name);