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

(1) Share

Report

Posted on by spidey1010

183

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)

Verified answer

Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (1)

Report
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

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 183 on at

Like (2)

Report

HI Layan,

Thanks for the response, SysTableLookup solved my problem.

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates