Microsoft Dynamics AX Blog

Today I will provide you document in which I have mentioned how to add Action Pane control in Forms. Action Pane Control

Today I will provide you document in which I have mentioned how to use fast tab control in AX 2012. Fast Tab Control

Today I will demonstrate you that how to use various type of joins in AX. Exist Join static void selectExistsJoin(Args _args) { CarTable carTable; RentalTable rentalTable; ; while select carTable exists join rentalTable where rentalTable.CarId == carTable.CarId { info(strfmt("CarId %1 has a matching record in rentalTable", CarTable.CarId)); } } Not Exist Join static void selectNotExistsJoin(Args _args) { CarTable carTable; RentalTable rentalTable; ; while select carTable notexists join rentalTable where rentalTable.CarId == carTable.CarId { info(strfmt("CarId %1 does not has a matching record in rentalTable", CarTable.CarId)); } } Outer Join static void selectOuterJoin(Args _args) { CarTable carTable; RentalTable rentalTable; ; while select carTable outer join rentalTable where rentalTable.CarId == carTable.CarId { if (!rentalTable.RecId) info(strfmt("No rentals for the car with carId %1", carTable

Today I will demonstrate you that how to use Like Operator in AX. static void RelationalOperatorLike(Args _args) { str carBrand = "Toyota"; ; // use the * wildcard for zero or more characters if (carBrand like "Toy*") { info ("The car brand starts with 'Toy'"); } // use the ? wildcard for one character if (carBrand like "Toy??a") { info ("The car brand starts with 'Toy' and the last character is 'a'"); } }