Dynamics Community Forum Thread Details

Unable to cast object of type 'Dynamics.AX.Application.FormStringControl' to type error

Hi,

I am trying to have a lookup for line numbers in a custom table by writing the code in event handler but getting this error -'Unable to cast object of type 'Dynamics.AX.Application.FormStringControl' to type 'Dynamics.AX.Application.FormReference'. What can be resolution for the same.

 [FormControlEventHandler(formControlStr(A, B), FormControlEventType::Lookup)]
    public static void B_LineNumber_OnLookup(FormControl sender, FormControlEventArgs e)
    {
        SysReferenceTableLookup tableLookup = SysReferenceTableLookup::newParameters(tableNum(X), sender);

        FormRun formRun =  sender.formRun();

        Query query = new Query();


        QueryBuildDataSource         qbds             = query.addDataSource(tableNum(X));          
        A                            solTable         = sender.formRun().dataSource(formDataSourceStr(A, B)).cursor();

        qbds.addRange(fieldNum(X, SolutionId)).value(solTable.SolutionId);

        tableLookup.parmQuery(query);
        tableLookup.addLookupfield(fieldNum(X, LineNumber));
        tableLookup.addLookupfield(fieldNum(X, SolutionId));

        tableLookup.performFormLookup();

        FormControlCancelableSuperEventArgs ce = e as FormControlCancelableSuperEventArgs;
        ce.CancelSuperCall();

       
    }

Please note I am getting an error at SysReferenceTableLookup line. I belive its because its fetching the recId but I want a string. Kindly let me know how may I tackle this error.

Categories:

Development / Customization / SDK

[FormControlEventHandler(formControlStr(A, B), FormControlEventType::Lookup)] //here it means form A control B public static void B_LineNumber_OnLookup(FormControl sender, FormControlEventArgs e) { SysTableLookup tableLookup = SysTableLookup::newParameters(tableNum(X), sender);// I replaced SysReferenceTableLookup with SysTableLookup FormRun formRun = sender.formRun(); Query query = new Query(); QueryBuildDataSource qbds = query.addDataSource(tableNum(X)); X xTable = formRun .dataSource(formDataSourceStr(A, X)).cursor(); //A is form so solTable should be of TypeX and not A and formDataSource should contain X and not B qbds.addRange(fieldNum(X, SolutionId)).value(xTable.SolutionId); tableLookup.parmQuery(query); tableLookup.addLookupfield(fieldNum(X, LineNumber)); tableLookup.addLookupfield(fieldNum(X, SolutionId)); tableLookup.performFormLookup(); FormControlCancelableSuperEventArgs ce = e as FormControlCancelableSuperEventArgs; ce.CancelSuperCall(); }

Quick Links

Leaderboard