• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Dropdown List box does not show display value when data window is retrieved

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Dropdown List box does not show display value when data window is retrieved

  1. How-to
0
Votes
Undo
  1. Falguni Patel
    Falguni Patel
  2. PowerBuilder
  3. Saturday, 17 April 2021 09:41 AM UTC

I have created a data window which has a dropdown lit box for Gender. 

When a new record is added, the field shows display value to select from. However, when a window is retrieved, column shows data value instead of display value.

I did write below function in retrieveend event of datawindow. But it gives - "Invalid Arguments to Function" error. 

 

string ls_display

   ls_display = dw_sort.describe &
      ( "evaluate ( 'LookupDisplay ( dept_id )', " &
         + string ( dw_sort.GetRow() ) &
         + " )" )


Regards,
Falguni
Theme: Change the color of the header band for Dat...
datawindow column style type of RichText
Accepted Answer
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Saturday, 17 April 2021 14:27 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi,

Can you please describe the problem a bit more extensive? I'm not sure what "gender" would have to do with "dept_id".
What do you mean with "When a new record is added, the field shows display value to select from. However, when a window is retrieved, column shows data value instead of display value.". Are you saying that when inserting a new row the dropdown is populated correctly, but when you open the window and show an already inserted row, the dddw does not populate?

Maybe some images?

Also, personally I always struggle with the "Evaluate" function. What I usually do, is add a computed column to the datawindow itself, which then uses the LookupDisplay(), much easier to use. From you powerbuilder script you can then do a GetItem...() on that computed column.

regards

Comment
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from this question.