[ic] mv_data_function=update is causing an insert

Tim Nelson interchange-users@icdevgroup.org
Mon Feb 3 14:23:01 2003


I know I am missing something obvious, but I have an
update form that is working fine when I set
mv_data_function=insert, but when I set
mv_data_function=update it is inserting a new record
instead of updating the current one.  
The index field (tph_id) is set so I am not sure
what criteria IC is using to determine it needs to do an
update instead of an insert.

Any ideas.  Thanks.


<FORM METHOD=POST ACTION="[process]" NAME=upd>
<INPUT TYPE=HIDDEN NAME="mv_data_table"    VALUE="test_plan_hdr">
<INPUT TYPE=HIDDEN NAME="mv_data_key"      VALUE="tph_id">
<INPUT TYPE=HIDDEN NAME="mv_form_profile"         VALUE="Check It">
<INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="update">
<INPUT TYPE=HIDDEN NAME="mv_update_empty" VALUE="1">
<INPUT TYPE=HIDDEN NAME="mv_nextpage"      VALUE="@@MV_PAGE@@">
<INPUT TYPE=HIDDEN NAME="mv_data_fields"
VALUE="prgmr_cd,prog_cd,tph_create_dt,tph_id,tph_mod_dt,tph_rel,tph_title">
<INPUT TYPE=HIDDEN NAME="tph_create_dt" VALUE="[time]%D[/time]">
<INPUT TYPE=HIDDEN NAME="tph_mod_dt" VALUE="[time]%D[/time]">
<INPUT TYPE=HIDDEN NAME="tph_id" VALUE="[value tph_id]">
.....
<INPUT TYPE=hidden NAME="mv_todo" VALUE="set">
<INPUT TYPE=submit VALUE="Insert Test Plan">

(IC 4.8.6 DBD::Informix)