Custom Error Message Before Insert
Posted: 2022-01-25 23:34
Hello board I need some help if you can. I need to get a custom error message built into my before update hook but nothing I am doing is working. I just get the standard 'Couldn't save the new record'. I am using v5.82
Code: Select all
function checklist_before_insert(&$data, $memberInfo, &$args) {
// WORK OUT MONTH YEAR
$UKDate=$_REQUEST['DateLeavingMonth'].$_REQUEST['DateLeavingYear'];
// set up unique check
$Uk=$data['EMPLOYEEID'].$UKDate;
// list the unique keys in an array
$res = sql("SELECT Unique_Check_Value FROM checklist",$eo);
WHILE($row = db_fetch_row($res)){
$uks[]=$row[0];
}
// if unique key already exists do not save the record
IF(in_array($Uk, $uks)){
return FALSE;
}else{
return TRUE;
}
}