It seems that select/option may not like numeric value converted to character. Here is my code.

 

*** GCOMMISSION is stored as a numeric with a value of 0.90

*** START EDIT FORM ***

*** Set The Vars

M.GCOMMISSION = STR(GCOMMISSION,3,2)

 

*** The Edit Form

<FORM>

  <SELECT NAME="gcommission" SIZE="1">
  <OPTION VALUE="0.85" <%=IIF(M.gcommission='0.85', 'SELECTED', '')%>>0.85</OPTION>
  <OPTION VALUE="0.90" <%=IIF(M.gcommission='0.90', 'SELECTED', '')%>>0.90</OPTION>
  </SELECT>

  <INPUT TYPE=SUBMIT NAME=btnchoice VALUE="Update">

</FORM>

 

The problem is that 0.90 is never automatically selected and it form always loads with 0.85. In the add form I am able to properly save the commission but the edit form fails. Am I missing something?

 

Joe