RE: Combo Box

Try clipping the p_code.

 

________________________________

From: [email protected] [mailto:[email protected]] On
Behalf Of Shaun Watts
Sent: Monday, June 12, 2006 4:06 PM
To: [email protected]
Subject: RE: [fourjs-users] Combo Box

 

I tried to clip the end of my variable, but it still does not display.

Here is my code that I am trying to implement.

 

function fill_combo(cb)
  define cb ui.ComboBox
  define p_query STRING
  define p_code  VARCHAR(10)
  define l_name VARCHAR(20)
  define f_name VARCHAR(20)
  define full_name VARCHAR(30)
  define i INT

 

   let p_query = "Select ofr_id,ofr_last,ofr_first from officers "
CLIPPED

 

  if cb.getTag()="cr_officer_id_no" then
      PREPARE q_comboList FROM p_query
      DECLARE c_comboList CURSOR FOR q_comboList

 

      ### Get list of values ###
      FOREACH c_comboList INTO p_code,l_name,f_name
         let full_name = f_name clipped," ",l_name clipped
         CALL cb.addItem(p_code,full_name clipped)
         let i = i + 1
      END FOREACH
  end if

 

end function

 

________________________________

From: [email protected] [mailto:[email protected]] On
Behalf Of Jean Gidcumb
Sent: Monday, June 12, 2006 9:01 AM
To: [email protected]
Subject: RE: [fourjs-users] Combo Box

Hi Shaun,

 

Yes. I have experienced this myself. What I found out is that if the
data being display has trailing spaces, then the value will not stay
displayed.

 

I hope that helps.

 

Jean Gidcumb

Programmer/Analyst 

Almost Family, Inc

502-891-1459

 

________________________________

From: [email protected] [mailto:[email protected]] On
Behalf Of Shaun Watts
Sent: Monday, June 12, 2006 8:41 AM
To: [email protected]
Subject: [fourjs-users] Combo Box

 

I am trying to use the combo box in Genero, but when I select my option
in my combo box it does not stay displayed.  Has anyone else had this
issue?  How can I fix it?

 

Thanks,

Shaun Watts

 

Programmer/Analyst

CSI - Computer Systems, Inc.         Phone:  317.913.4160
12975 Parkside Drive                          Fax:  317.913.4175
Fishers, IN  46038                       Toll Free:  800.860.1274

 

"To conquer fear is the beginning of wisdom."
- Bertrand Russell