I want to use Multi-Update to execute my custom sql statement
but I don't want to use the multi-update function itself, so I cancel it before it executes the multi-update.
Currently I have it to return false but I still want a green toast message showing that my sql statement was successfully executed.
How can I modify it?
// Row Updating event
function Row_Updating($rsold, &$rsnew)
{
// Enter your code here
if ($this->CurrentAction == "update") {
// ...
$sql = "INSERT INTO other_Table (field1, field2, field3) VALUES ('...', '...', '...');"
ExecuteScalar($sql);
return false;
}
// To cancel, set return value to false
return true;
}