update record in formdatasource extension

(0) Share

Report

Posted on by dark_knight

1,271

Hello,

I'm trying to update the record in write() method of the standard formdatasource extension. t

[ExtensionOf(FormDataSourceStr(PurchCreateOrder, PurchTable))]
internal final class PurchCreateOrder_Form_PurchTableDS_Extension
{
    void write()
    {
        next write();

        FormDataSource purchTableDS = this;
        Purchtable purchTableCursor = purchTableDS.cursor() as PurchTable;
        PurchTable purchTable = Purchtable::find(purchTableCursor.PurchId,true);

        ttsbegin;

        purchTable.TaxGroup = sometable::find(purchtable.InventSiteId,purchtable.InventLocationId).TaxGroup;
        purchTable.DefaultDimension = changeFinancialDimensionValue(purchTable.DefaultDimension,
                                                                    'Location',
                                                                    sometable::find(purchTable.InventSiteId,purchTable.InventLocationId).LocationFinDim
                                                                    );
        purchTable.update();


        ttscommit;
    }

}

the record is already inserted in standard write() method. then I get the cursor and it contains purchid value but then the system doesn't find purchtable. it's always null value. what am I doing wrong? I tried simply use purchTable without finding cursor. It's also doesn't work. FO doesn't see it in the code below saying that purchTable isn't reachable:

[ExtensionOf(FormDataSourceStr(PurchCreateOrder, PurchTable))]
internal final class PurchCreateOrder_Form_PurchTableDS_Extension
{
    void write()
    {
        next write();


        ttsbegin;
        
        
        purchTable.selectforupdate();
        purchTable.TaxGroup = sometable::find(purchtable.InventSiteId,purchtable.InventLocationId).TaxGroup;
        purchTable.DefaultDimension = changeFinancialDimensionValue(purchTable.DefaultDimension,
                                                                    'Location',
                                                                    sometable::find(purchTable.InventSiteId,purchTable.InventLocationId).LocationFinDim
                                                                    );
        purchTable.update();


        ttscommit;
    }

}

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Suggested answer

Komi Siabi 13,218 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi, could you tell us what is to trigger the system to update the record ?

At what point do you want to update this record?

Was this reply helpful? Yes No
dark_knight 1,271 on at

Like (0)

Report
Copy link

Link copied!

It's standard PurchCreateOrder form (called when you create new PurchOrder in user interface) and purchtable is inserted in PurchTableDS write() method.

Was this reply helpful? Yes No
Komi Siabi 13,218 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What is the business scenario ?

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Azat,

You need to create new buffer for PurchTable and get the current cursor like below.

PurchTable purchTableBuffer;

purchTableBuffer = this.cursor();

Now you can get the value in the purchTableBuffer.

Thanks,

Girish S.

Was this reply helpful? Yes No
Mariano Gracia on at

Like (0)

Report
Copy link

Link copied!

The purchcreateorder form is a bit special, I suggest you to use the public variable purchTableForm in the write method extension, and then call the method purchTableForm.purchTable(), it will give you the purchtable record created by the form.

Was this reply helpful? Yes No
dark_knight 1,271 on at

Like (0)

Report
Copy link

Link copied!

The purchcreateorder form is a bit special, I suggest you to use the public variable purchTableForm in the write method extension, and then call the method purchTableForm.purchTable(), it will give you the purchtable record created by the form.

Like0 Likes

Moderate

thanks. interesting.

do you have an example?

Was this reply helpful? Yes No
Verified answer

Mariano Gracia on at

Like (0)

Report
Copy link

Link copied!
You'll need two extensions, the first one to make the PurchTableForm variable accessible:

[ExtensionOf(formStr(PurchCreateOrder))] public final class PurchCreateOrderGVC_Extension { //We need to access the purchTableForm variable, so we make a new method to return it public PurchTableForm purchTableForm() { return purchTableForm; } }

and the second one an extension of the PurchTableCreateOrder's PurchTable datasource in wich you'll update the record in the write event, now I only show an info so you can verify you get the record you want to modify:

[ExtensionOf(formDataSourceStr(PurchCreateOrder, PurchTable))] public final class PurchCreateOrder_PurchTableGVC_Extension { //write extension on the datasource to access the created PurchTable record void write() { next write(); if (element.closedOk()) { FormRun formRun = this.formRun(); if (formHasMethod(formRun, identifierStr(purchTableForm))) { PurchTableForm purchTableFormLocal = formRun.purchTableForm(); PurchTable purchTableToUpdate = purchTableFormLocal.purchTable(); info(purchTableToUpdate.PurchId); } } } }

Was this reply helpful? Yes No
dark_knight 1,271 on at

Like (0)

Report
Copy link

Link copied!

thank you. will do

Was this reply helpful? Yes No