Skip to main content

Posts

Update records and grid in MSD axapta x++ language

Update records and grid in axapta x++ language public void Update_test_Emp_Travel() { ; ttsbegin; Select forUpdate test_Emp_Travel where test_Emp_Travel.SrNo == str2num(rlSrNo_Update.valueStr()); test_Emp_Travel.Employee_Name = strEmployeeName_Update.valueStr(); test_Emp_Travel.Travelling_Through = str2enum(test_Travelling_Through,cmbTravellingThrough_Update.valueStr()); test_Emp_Travel.update(); ttscommit; test_Emp_Travel_ds.reread(); test_Emp_Travel_ds.refresh(); test_Emp_Travel_ds.research(true); test_Emp_Travel_ds.executeQuery(); element.ClearField_Update(); GridEmpTravel.update(); GridEmpTravelDetails.update(); }

Insert Records and update grid in MSD axapta

 Insert Records and update grid in axapta x++ public void Insert_test_Emp_Travel() { ; test_Emp_Travel.SrNo = str2num(rlSrNo.valueStr()); test_Emp_Travel.Employee_Name = strEmployeeName.valueStr(); test_Emp_Travel.Travelling_Through = str2enum (test_Travelling_Through,cmbTravellingThrough.valueStr()); test_Emp_Travel.insert(); test_Emp_Travel_ds.reread(); test_Emp_Travel_ds.refresh(); test_Emp_Travel_ds.research(true); test_Emp_Travel_ds.executeQuery(); element.ClearField_Insert(); GridEmpTravel.update(); GridEmpTravelDetails.update(); }

The number to convert to a text string using MSD axapta x++

num2Str info("num2Str(real number,int character,int decimals,int separator1,int separator2)"); info("number - The number to convert to a text string."); info("character - The minimum number of characters required in the text."); info("decimals - The required number of decimals."); info("separator1 - The decimal separator. Possible values: 1 – point (.) and 2 – comma (,)"); info("separator2 - The thousands separator. Possible values: 0 – no thousands separator ,1 – point (.) ,2 – comma (,) ,3 – space ( )"); info("num2Str(12345.6,1,2,1,2) " + num2Str(12345.6,1,2,1,2));   

Dialog in Report using MSD axapta x++ language

Dialog in Report //1. Class Declaration public class ReportRun extends ObjectRun { dialogField dftest_Enum_EDT; dialogField dfFromDate,dfToDate; dialogGroup dialogGroup; test_Enum_EDT test_Enum_EDT; Date dtFrom,dtTo; str strtest_Enum_EDT; } //2. Dialog public Object dialog(Object _dialog) { DialogRunbase dialog = _dialog; ; dialogGroup = dialog.addGroup("DialogGroup"); dftest_Enum_EDT = dialog.addField(typeid(test_Enum_EDT)); //dialog.addFieldValue(typeid(test_Enum_EDT)); dfFromDate = dialog.addField(typeId(FromDate));//dialog.addFieldValue(typeId(FromDate),dtFrom); dfToDate = dialog.addField(typeId(ToDate));//dialog.addFieldValue(typeId(ToDate),dtTo); return dialog; } //3. getFromDialog public boolean getFromDialog() { ; strtest_Enum_EDT = dftest_Enum_EDT.value(); test_Enum_EDT = dftest_Enum_EDT.value(); dtFrom = dfFromDate.value(); dtTo = dfToDate.value();

Overwrites part of a text string with another text string in MSD axapta x++

strPoke (Overwrites part of a text string with another text string) info("str strPoke(str _text1,str _text2,int _position)"); info("Overwrites part of a text string with another text string."); info("_text1 - The original string."); info("_text2 - The string to replace part of _text1 with."); info("_position - The position in _text1 at which to begin replacing the characters."); info("strPoke(\"123456\",\"AAA\",3) " + strPoke("123456","AAA",3));