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

(1) Share

Report

Posted on by spidey1010

203

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.

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi,

So you have form 'A' with control 'B'. What's the type of control 'B'? is it string?
Why you are not using SysTableLookup instead of SysReferenceTableLookup?

And I'm confused, which table do you want to use. Sometimes you put X, sometimes you put B and sometimes you put A?

I assume you want X

maybe you meant the code to be like this? (just trying to re-write it quickly)
[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(); }

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

Please share us the exact code since we are not able to understand what is being used in the lookup as a table and also if you need a recid or string since you are using SysTableReferenceTableLookup. Also please give us more information on the business requirement.

Was this reply helpful? Yes No
spidey1010 203 on at

Like (2)

Report
Copy link

Link copied!

HI Layan,

Thanks for the response, SysTableLookup solved my problem.

Was this reply helpful? Yes No