string outer
, объявленный на уровне класса, и на присвоение переменной внутри jsecex outer = outjs.ToString();
DELIMITER $
CREATE TRIGGER `update_balance` AFTER UPDATE ON `trading`
FOR EACH ROW BEGIN
IF (NEW.`line` = 'up' AND NEW.`price_end` > NEW.`price`) THEN
UPDATE `clients` SET `balance` = `balance` + NEW.`sum` * 1.85 WHERE `email` = NEW.`user_id`;
ELSEIF (NEW.`line` = 'down' AND NEW.`price_end` < NEW.`price`) THEN
UPDATE `clients` SET `balance` = `balance` + NEW.`sum` * 1.85 WHERE `email` = NEW.`user_id`;
END IF
END;
$
DELIMITER ;
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 8