function sqlCommonTermAddEdit()
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $glUserID;
$term =& $this->terms[0];
$strOut = '
crs_bCompareBool = ' . strDBValueConvert_BOOL($term->bCompareBool) . ',
crs_lCompVal = ' . strDBValueConvert_INT($term->lCompVal) . ',
crs_curCompVal = ' . strDBValueConvert_SNG($term->curCompVal, 2) . ',
crs_strCompVal = ' . strDBValueConvert_String($term->strCompVal) . ',
crs_dteCompVal = ' . strDBValueConvert_String($term->mdteCompVal) . ",\n crs_lCompareOpt = {$term->lCompareOpt},\n crs_lSortIDX = {$term->lSortIDX},\n crs_lLastUpdateID = {$glUserID},\n crs_dteLastUpdate = NOW()\n ";
return $strOut;
}
private function strCommonFieldSQL()
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $glUserID;
$ufield =& $this->fields[0];
return '
pff_strFieldNameUser = '******',
pff_strFieldNotes = ' . strPrepStr($ufield->strFieldNotes) . ',
pff_bCheckDef = ' . strDBValueConvert_BOOL($ufield->pff_bCheckDef) . ',
pff_curDef = ' . strDBValueConvert_SNG($ufield->pff_curDef, 2) . ',
pff_strTxtDef = ' . strDBValueConvert_String($ufield->pff_strTxtDef) . ',
pff_lDef = ' . strDBValueConvert_INT($ufield->pff_lDef) . ",\n pff_lCurrencyACO = " . (int) $ufield->pff_lCurrencyACO . ",\n pff_bPrefilled = " . ($ufield->bPrefilled ? '1' : '0') . ",\n pff_bHidden = " . ($ufield->pff_bHidden ? '1' : '0') . ",\n pff_bRequired = " . ($ufield->pff_bRequired ? '1' : '0') . ",\n pff_lLastUpdateID = {$glUserID},\n pff_dteLastUpdate = NOW() ";
}
