1. Bjarne Anker
  2. PowerBuilder
  3. Thursday, 6 September 2018 12:24 PM UTC

Hi.

 

I have a datawindow with a dropdowndatawindow.

The dddw contains 3 colums: ID, Description, Category.

For the column in the main datawindow, I have chosen the ID column as "Data Column" and Category as the "Display Column".

When we type in the dropdowndatawindow, the program searches in the "Category" column.

However, one of our customers wants to search in the "Description" column in the dropdowndatawindow.

 

Is this at all possible?

I've tried to implement the PFC functionality in of_setdropdownsearch() and of_register(), but it doesn't look like it has any effect.

 

Thanks in advance.

 

Bjarne Anker

Maritech Systems AS

Norway

René Ullrich Accepted Answer Pending Moderation
  1. Friday, 7 September 2018 05:33 AM UTC
  2. PowerBuilder
  3. # 1

If you want to use the PFC dropdown search service you have to implement two events:

 

editchanged:

IF IsValid (inv_dropdownsearch) THEN inv_dropdownsearch.event pfc_editchanged(row, dwo, data)

 

itemfocuschanged:

IF IsValid (inv_dropdownsearch) THEN inv_dropdownsearch.event pfc_itemfocuschanged (row, dwo)

 

 

 

Comment
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 6 September 2018 16:38 PM UTC
  2. PowerBuilder
  3. # 2

The best answer for this customer issue is to add a new DDDW in the DESCRIPTION column, and have that DDDW search on the description field, which is approriate.


Olan

Comment
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 6 September 2018 13:42 PM UTC
  2. PowerBuilder
  3. # 3

"When we type in the dropdowndatawindow, the program searches in the "Category" column.
However, one of our customers wants to search in the "Description" column in the dropdowndatawindow."

So do I understand that while being positioned in the column with the column with the category dddw, you want to search in the column description which is also in that dddw? You want to display the Category, but search on the Description?

I think you would have to do the search "manually" (by coding) in the editChanged() event of the column:

- do a GetChild() and use the find() function and scrolltorow(). I guess it's best to do the scrollToRow() with POST, to avoid conflict with the "automatic" behaviour of scrolling to the category while as you're typing.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.