Get datasource form from class extension in AX7

(0) Share

Report

Posted on by Ferdiansah

403

Hi all,

How to get datasource form from class extension in AX7 ?. I use FormRun but there is an error object reference not set to an instance of an object. This is my code

[ExtensionOf (classStr(SalesTableType))]
final class SalesTableType_SO_Extension
{
    protected NumberSeqFormHandler numberSeqFormHandlerSalesId(FormRun _element, FormDataSource _salestable_ds)
    {
        NumberSeqFormHandler numberSeqFormHandlerSalesId = next numberSeqFormHandlerSalesId(_element, _salestable_ds);
        FormRun fr;
        FormDataSource fds = fr.dataSource("SalesTable");
        
        NumberSequenceTable     numSeqTable;
        RefRecId                recIdNumSeq;
        ZSetupSalesType         zsalestype; 
        SalesTable          _salesble = fds.cursor();
        select zsalestype where zsalestype.SalesType == _Salesble.ZSalesType
                && zsalestype.Site == _Salesble.InventSiteId;
        if(zsalestype)
        {
            select numSeqTable where numSeqTable.NumberSequence == zsalestype.SalesOrder;
            recIdNumSeq = numSeqTable.RecId;
            if(numSeqTable)
            {
                if (!numberSeqFormHandlerSalesId)
                {
                    numberSeqFormHandlerSalesId = NumberSeqFormHandler::newForm(recIdNumSeq,
                                                                         fr,
                                                                         fds,
                                                                         fieldNum(SalesTable, SalesId)
                                                                        );
                    return numberSeqFormHandlerSalesId;
                }
                
            }
        }
        return numberSeqFormHandlerSalesId;
    }

}

Thanks,

Categories:

Development / Customization / SDK

I have the same question (0)

All responses (7)

Answers (1)

Jie G on at

Like (0)

Report

RE: Get datasource form from class extension in AX7

Hi Ferdiansah,

FormRun.dataSource Method is used to get form's datasource: docs.microsoft.com/.../gg906246(v=ax.60)

Would please let us know where the error "object reference not set to an instance of an object" is from in the code and which object it refers?

Was this reply helpful? Yes No
Jie G on at

Like (0)

Report

RE: Get datasource form from class extension in AX7

The" FormRun fr " is not initialized. Have your tried to set it like " FormRun fr = _element;"

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Get datasource form from class extension in AX7

Suggesting a way when using events

[FormDataSourceEventHandler(formDataSourceStr(FMRental, FMRental), FormDataSourceEventType::ValidatingWrite)]

public static void FMRental_OnValidatingWrite(FormDataSource sender, FormDataSourceEventArgs e)

{

var datasource = sender as FormDataSource;

Was this reply helpful? Yes No
Suggested answer

syed baber 11,633 on at

Like (0)

Report

RE: Get datasource form from class extension in AX7

Hi Ferdiansah,

The error is due to the fact that you haven't initialized FormRun variable 'fr'. Assign it to _element variable and then you should be all good.

Please let me know if you have further queries.

Thanks,

Baber.

Was this reply helpful? Yes No
Sukrut Parab 71,699 Moderator on at

Like (0)

Report

RE: Get datasource form from class extension in AX7

Agree with Baber. make sure you have assigned element to fr and the get datasource from formRun

Was this reply helpful? Yes No
Suggested answer

Sheikh Sohail 6,125 on at

Like (0)

Report
RE: Get datasource form from class extension in AX7

Hi

Check the highlighted area where you were doing mistake

[ExtensionOf (classStr(SalesTableType))] final class SalesTableType_SO_Extension { protected NumberSeqFormHandler numberSeqFormHandlerSalesId(FormRun _element, FormDataSource _salestable_ds) { NumberSeqFormHandler numberSeqFormHandlerSalesId = next numberSeqFormHandlerSalesId(_element, _salestable_ds); FormRun fr; // it should be like FormRun fr=_element; FormDataSource fds = fr.dataSource("SalesTable"); NumberSequenceTable numSeqTable; RefRecId recIdNumSeq; ZSetupSalesType zsalestype; SalesTable _salesble = fds.cursor(); select zsalestype where zsalestype.SalesType == _Salesble.ZSalesType && zsalestype.Site == _Salesble.InventSiteId; if(zsalestype) { select numSeqTable where numSeqTable.NumberSequence == zsalestype.SalesOrder; recIdNumSeq = numSeqTable.RecId; if(numSeqTable) { if (!numberSeqFormHandlerSalesId) { numberSeqFormHandlerSalesId = NumberSeqFormHandler::newForm(recIdNumSeq, fr, fds, fieldNum(SalesTable, SalesId) ); return numberSeqFormHandlerSalesId; } } } return numberSeqFormHandlerSalesId; } }

Was this reply helpful? Yes No
Verified answer

Ferdiansah 403 on at

Like (0)

Report
RE: Get datasource form from class extension in AX7

It's done. I just use parameter _salestable_ds from method parameter, and write

Salestable _salestable = _salestable_ds.cursor();

Was this reply helpful? Yes No