how to display lookup in stringEdit form's control?

(0) Share

Report

Posted on by BASMA

932

hello ,

I want to add lookup in line details(accounts receivable> sales order >all sales order)

this lookup displays data from cutomized table only for the current customer :

this is the table :

I add new stringEdit control and i add this code in OnLookup event handler :

[FormControlEventHandler(formControlStr(SalesTable, INTGroupingCode), FormControlEventType::Lookup)]
    public static void INTGroupingCode_OnLookup(FormControl sender, FormControlEventArgs e)
    {
        Query query = new Query();
        SalesTable salesTable = sender.formRun().dataSource("SalesTable").cursor();
        QueryBuildDataSource queryBuildDataSource;
        QueryBuildRange queryBuildRange;
        SysTableLookup sysTableLookup;
        sysTableLookup = SysTableLookup::newParameters(tableNum(INTGroupingCodeTable),sender);
        queryBuildDataSource = query.addDataSource(tableNum(INTGroupingCodeTable));
        queryBuildRange = queryBuildDataSource.addRange(fieldNum(INTGroupingCodeTable,CustomerAccount));
        queryBuildRange.value(queryValue(salesTable.custAccount));
        
        sysTableLookup.addLookupField(fieldNum(INTGroupingCodeTable,GroupingCode ),true);
        sysTableLookup.addLookupField(fieldNum(INTGroupingCodeTable, Description),true);
        
        sysTableLookup.parmQuery(query);
        sysTableLookup.performFormLookup();
    }

but I can't display data.

I have the same question (0)

All responses (12)

Answers (1)

GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Basma,

Can you elaborate more?

What do you mean by I can't display data?

Is there any error or lookup field is not editable?

Thanks,

Girish S.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Copy link

Link copied!

hello,

yes when I click on edit , the stringRdit is not editable :

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

Like (0)

Report
Copy link

Link copied!

What is the purpose of this string edit control you added? Seems it's a DataSource unbound control

From the screenshot there is no Sales order line created - Try creating new sales line and check whether its editable.

Thanks,

Girish S.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Copy link

Link copied!

yes it's an unbound control ,

the purpose is :

I have a customized table that contains codes for customer.

I want to display on lookup , only codes for the current customer.

there is no reltion between sales order lines and the lookup

Was this reply helpful? Yes No
Verified answer

GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

Okay, have you tried creating a new record on sales order lines?

Just click on Add line button on sales order line tab and see whether the control is editable.

Thanks,

Girish S.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Copy link

Link copied!

thanks Girish,

When I create a new line , I show the data on lokkup.

Was this reply helpful? Yes No
Suggested answer

GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

But keep in mind that if you make this control as unbound - This value cannot be saved any where on the table and its just for viewing purpose only. User can select the value from the lookup and the value will be displayed - But you cannot get the selected value if you need that in any of the process later.

Thanks,

Girish S.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Copy link

Link copied!

thanks for reply,

yes I change this control, and i add new field in SalesLine

then I add it in the form for save the value .

also I add this field :

can I add also lookup in grid for the same field?

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

Like (0)

Report
Copy link

Link copied!

Yes, you can add a same lookup code where you have added for your unbound string control. Just copy the lookup event handler for the control you created - Paste the event handler in your custom class - Now copy the code you had written for unbound control and paste it in the lookup method.

Thanks,

Girish S.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Copy link

Link copied!

I'm talking about the new fields that I added in SalesLine,

I added it in 2 places (line details , grid) :

I can use the same lookup ?

Was this reply helpful? Yes No