Skip to Content
author's profile photo
Former Member

How to show ChooseFromList in Matrix

Oct 04, 2005 at 03:54 PM | 9 Views

Hi there,

Is there anyone can tell me how to show ChooseFromList

dialog in a column of matrix grid.

I define a ChooseFromList and bind the CFL to a column

use [column.ChooseFromListUID] property, and the matrix

bind with datasource.

the prolem is that CFL can show after press TAB key

in column, but after choose one row, the new CFL dialog

will show again. who have faced the similar problem and

can tell me the tips to work around this problem.

Thanks!

Lanjun Wang

SAP Business One Extensibility
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Barend Morkel
    Oct 05, 2005 at 06:10 AM

    1. SBO 2004 does not allow this functionality. You must build your own "ChooseFromList" to accomplish this.

    2. SAP stated that this functionality will be available in 2005

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Rasmus Wulff Jensen
    Oct 05, 2005 at 06:17 AM

    Sounds like your not test the beforeAction and get the event twice. After adding the CFL to the item do something like this

    if(pVal.ItemUID=="BOY_2" && pVal.EventType == BoEventTypes.et_CHOOSE_FROM_LIST) {
  ChooseFromListEvent cflEvent = (ChooseFromListEvent)pVal; 
  string cflUID = cflEvent.ChooseFromListUID; 
  if(!pVal.BeforeAction) {
    DataTable dt = cflEvent.SelectedObjects;
    if(dt!=null && dt.Columns.Count!=0 && dt.Rows.Count!=0) {
      string værdi = dt.GetValue("ItemCode",0).ToString();
      eventForm.DataSources.UserDataSources.Item("BOY_UDS1").ValueEx = værdi;
    }
  }
}

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Oct 05, 2005 at 07:15 PM

      Hi, there

      Now I find the reason that CFL dialog show more than one times, is because the code:

      cellval = oMatrix.Columns.Item("DSCardCode").Cells.Item(pVal.Row).Specific

      cellval.value = val

      when run Code [cellval.value = val], a new CFL dialog will show, now I will try another way to fill the matrix cell value, so the problem change to other two problems:

      1. How to show the new value to Matrix cell, the Matrix bind with datasource.

      2. After input content in cell which in column that link to CFL, when press Tab Key or leave cell the new CFL dialog always show again.

      If someone know the reason of this problem please give answer.

      Thanks in advance.