How do I get Popup to display all values in multivalue column?

It displays only the 1st value as far as I can figure it out.

Wouldn't you have to program your own data explode to normalize all the rows against the multivalues? Ugh. You could cheat, and create a symbolic column for the multivalues which uses a delimiter below FA. Then add a text zoom feature to the column which would display a popout list of the values.

This last part is really, really hard because popups are modal and so you are not given the choice of executing anything on top. For this reason I usually deprecate popups in my own development. Instead, I write display windows with edit-tables and then my zOOm utility automagically allows viewing of multivalues.

How do I get Popup to display all values in multivalue column? It displays only the 1st value as far as I can figure it out.

It is true that only the first value will be displayed. You could create a symbolic field that swaps the @vm with a comma (,) or other character and then have the popup use the symbolic field.

You are able to show all multivalues within their own popup. In the UI Workspace you could create a popup using Columns from a Row as the Source. You could then drill down from the main popup to this popup. This may be useful if you need to select on a multivalue.

Sean

Kauko,

Not sure, but is this what you what you see:

In this example, the last column in this popup is a MV text field. The MV could be something other than a text field.

Ray Chan

How do you accomplish this?

I get only one line output in popups?

Kauko,

Below is snippet of code. I think that you will get the idea.

pre.code {

background-color: #E5E5E5;

border: 1px solid #000000;

width: 450px;

padding: 5px;

font-family: courier, verdana, arial, serif;

margin: 0px 10px auto;

}

SAMPLE CODE
// * this is in a Loop-Repeat
Loop
…
Read Text from QMR_fh, ID Else null
   Desc=Text
   Cmt =Text
   Cmt =Fmt(Cmt,"T#55")
   
    // * Count how many items in the multivalue field
   Cnt=Count(Cmt ,@TM)+1
   /*
     Because this is a TM delimited field, convert to @vm or @fm.
     Your preference.
  */
   Convert @TM TO @VM IN Cmt
   For I=1 TO Cnt
         ML_Cmt=Cmt

          If I=1 Then
                // * rec.cnt=line in popup
                Rec.Cnt+=1

                // * Notice @svm separate columns in popup	
                Display=ID: @svm: Desc: @svm: ML_Cmt
           End Else
                

               Rec.Cnt+=1
                // * Notice @svm separate columns in popup
                // * This will display Multi-Value items after row #1
	
                Display= ": @svm : @svm : ML_Cmt
            End
      Next I
     REC.CNT+=1

  Repeat

 // * When done stuff Display into Popup Parameter. See Popup_Equates
 
TypeOverRide  =Display
RtnPU_Item=Popup(@Window,TypeOverRide,"name of your popup")

Hope this helps. Isn't it GREAT to be able to work with multi-value fields!

Ray Chan

Kauko,

Had a typo. Correction to code, see

TypeOverRide =Display

Ray Chan

Okay last time.

pre.code {

background-color: #E5E5E5;

border: 1px solid #000000;

width: 450px;

padding: 5px;

font-family: courier, verdana, arial, serif;

margin: 0px 10px auto;

}

TypeOverRide  =Display

Just figured out that I was losing the content between brackets. In case it doesn't show again, the line show read:

TypeOverRide Angle Bracket PDisplay$ Angle Bracket

HTH,

Ray Chan

Thanks.

Need to study that. At the meantime I wrote edittable routine using SRP's OLE package to do the same.

… At the meantime I wrote edittable routine using SRP's OLE package to do the same.

Those SRP's OlE are nice. Very very pretty and very professional looking.

Ray Chan

View this thread on the Works forum...