Skip to main content

Generating and running code RUNTIME.

How to create, compile and run code at RUNTIME.

In some situations the need for making "generic" code arises.

This is a little example that generates, compiles and runs code to delete the contents of table PBACustGroup.

The code is made as a job, but transforming this code into a method on a class, and calling this method with parameters that allows it to identify the table, suddenly makes us able to delete several selected tables with very little code.
It also allows for USER CONTROLLED actions, for example letting the user build a liste of tables he would like to delete, and then calling the code for each of these tables.


static void TestGenericCode(Args _args)
{
    XppCompiler XppCompiler;
    str code;
    str tableName = "PBACustGroup"; // Here we define the name of the table
;

    // A compile object is created
    XppCompiler = new XppCompiler();
    // Here the code to delete the tabel is created
code = "void x() {"+tableName+" "+tablename+"; ttsbegin; delete_from "+tableName+"; ttscommit; }";
    // And compiled
    if (XppCompiler.compile(code))
    {
        // If the compiler was satisfied with the code we run it
        XppCompiler.execute();
        // And inform the user that we deleted data
        info("Deleted all record in table "+tableName);
    }
    else
    {
        // Otherwise the compiler lets us know the code was errorneous
        info(XppCompiler.errorText());
info("fejl !!");
    }
}

Labels

Labels:

Comments

  1. UnknownAugust 7, 2011 at 4:16 PM

    Hello,

    I've read your blog posts and I find them very interesting and helpful.

    I have a task to accomplish, but don't know how. I'll explain you what's about and how I'd like to solve it.

    I have to migrate selective subset of data from one aos to another (eg. all CustTable rows where name="John").
    I thought to create a method on the first aos that gathers the data and send the table container to a web service. The WS would then write into the second aos instance.
    I've also thought to code it using reflection to make it more generic and reusable, but since I'm not an expert X++ coder (I'm stronger in C# and Java) I'm stuck with this implementation.

    Do you know a better way to solve my problem? Can you give me some ideas?

    Thank you in advance and keep posting,
    Francesco

    ReplyDelete

Post a Comment

Popular posts from this blog

Suppressing the infolog

Supressing the infolog is often useful in D365FO when augmenting code. When augmenting code using COC (Chain Of Command), you can have new code run either before or after the code you are augmenting. This means that any infolog-messages that the standard application code does, will be shown to the user, even if your augmentation supports a scenario where there must be no infolog-messages. How do you avoid the standard application infolog-messages ? To the rescue comes temporary supression of the infolog. The suppression consists of: 1) Saving the current infologLevel 2) Setting the infologLevel to SysInfologLevel::None 3) Run your code 4) Restoring the saved infologLevel to the infolog For example a table could have a validatewrite-method that validates that you are only allowed to use 3 out of 6 options in an enum-field, and you need to allow for a fourth one. Table a - validateWrite method: boolean validateWrite() {     Switch (this.enumField)     {     ...
Post a Comment
Read more

Dynamics AX 2012 ValidTimeState tables and form changing view from current to all

Valid Time State tables are new i AX 2012 a gives the developer the possibility to easily create tables that hold e.g. current setup data for various purposes, and at the same time keeping a "history" of the changes of the data in the table. For more reading: http://msdn.microsoft.com/en-us/library/gg861781.aspx I was tasked with doing a setup table with rates for calculating Vendor Bonus and I chose to base this a valid time state table. The customer asked for a button on the form, where you maintain the vendor bonus calculation setup data, so you could toggle viewing "Current setup" or "All setup" records (changing the view from actual to all records and vice versa in the form). I found that you can not change the ValidTimeStateAutoQuery property on the form data source in a form at run-time. It simply does not change anything, so I came up with the following solution: A boolean class member in the classdeclation method of the form: boolean ...
Post a Comment
Read more

ProcessGuide framework

I was tasked with developing a custom "process" for printing ad hoc labels in the Dynamics 365SCM WHS app. WHS process guide - development docs Reading the great articles from 1clickfactory (starting point  https://www.1clickfactory.com/blog/advanced-whs-mobile-device-development-part-1-process-guide-framework/) gives a good starting point. Especially Edgaras' tip on running  SysExtensionCache::clearAllScopes();  in a runnable class after introducing a new step/pagebuilder class combination  is VERY useful. And of course Microsoft's own documentation ( https://docs.microsoft.com/en-us/dynamics365/supply-chain/warehousing/process-guide-framework ) also helps. However, I wanted to chip in with a couple of things. Extending WHS base enums If you extend the WHSActivity, WHSWorkExecuteMode or WHSWorktransType base enums with new options it is a good idea to run a database synchronization when you are done with extending them. Otherwise you might be frustrated to find, th...
1 comment
Read more