Skip to main content

select All Records Dynamically in axapta

This is sample code to select All Records Dynamically in axapta

 static void selectAllRecordsRuntimeArgs _args)  
 {  
 firstTable firstTable;  
 DictField dictField;  
 DictTable dictTable;  
 int field;  
 int fieldId;  
 int records;  
 str header, line;  
 ;  
 // Create a new object of type DictTable based on the firstTable  
 dictTable = new DictTable(tablenum(firstTable));  
 // Loop through the fields on the table.  
 // For each field, store the field-label in the header variable.  
 for (field=1; field <= dictTable.fieldCnt(); field++)  
 { fieldId = dictTable.fieldCnt2Id(field);  
  dictField = new DictField(tablenum(firstTable), fieldId);  
 header += strfmt("%1, ", dictField.label()); }  
 info(strupr(header)); // strupr changes the string to UPPERCASE // Loop through all the records in the firstTable while select firstTable  
 { line = "";  
  // For each record in the firstTable, loop through all the //fields // and store the value of the field for this record in the //line variable.  
  for (field=1; field <= dictTable.fieldCnt(); field++)  
 { fieldId = dictTable.fieldCnt2Id(field); dictField = new DictField(firstTable.TableId, fieldId);  
  // Instead of referencing to the fieldname, I reference to  
 //field ID // to get the fields value.  
 line += strfmt("%1, ", firstTable.(fieldId));  
  } info(line);  
 records++;  
 }  
 info(strfmt("%1 records were selected", records));  
 }   

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);