void fAddField_SQLUpdate(Tform_rec *pparms, char *pcmd, char *pform_field, 
       char *pdb_field, int bvis_too) {

/* add specified field and value to SQL command string; clean up    */
/*   values as we go                                                */
/* string ultimately comprises a SQL update-existing-record command */

  char *pstr;
  char sbuf[iBUFSIZE], sval[iBUFSIZE];

/* if Web form value is not found, don't do anything                 */
/* note: even if value is empty string, we still need to process it, */
/*   as it may be replacing a previous non-empty value               */

  if ((pstr = fWeb_Form_Val(pparms, pform_field)) == NULL)
    return;

  fCleanUpValue(sval, sizeof(sval), pstr);
  sprintf(sbuf, ",%s='%s'", pdb_field, sval);
  strcat(pcmd, sbuf);

/* if saving visibility flag, construct appropriate field names */
/*   and add current value                                      */

  if (!bvis_too)
    return;

  sprintf(sbuf, "%s%s", pform_field, sVIS_SUFFIX);
  if (((pstr = fWeb_Form_Val(pparms, sbuf)) == NULL) || !strlen(pstr))
    return;

  sprintf(sbuf, ",c%s%s='%s'", (pdb_field + 1), sVIS_SUFFIX, pstr);
  strcat(pcmd, sbuf);

  return;
}