2,209
社区成员




CREATE TRIGGER IF NOT EXISTS trigger_al_i BEFORE INSERT ON asset_lists
FOR EACH ROW
BEGIN
SELECT CASE
WHEN name = NEW.name THEN RAISE(ABORT, '新增资产与编号为 ' || lid || ' 的资产名称冲突。')
WHEN pinyin = NEW.pinyin THEN RAISE(ABORT, '新增资产与编号为 ' || lid || ' 的资产拼音冲突。') END
FROM asset_lists WHERE name = NEW.name OR pinyin = NEW.pinyin;
END;