COMMENT->eQSL.qslmsg Trigger

Post Reply
VK2MET
Advanced Class
Posts: 70
Joined: 24 Apr 2021, 23:24

COMMENT->eQSL.qslmsg Trigger

Post by VK2MET »

Can I suggest the installation of a simple trigger.
To solve the issue of the eQSL->qslmsg field needing contents from the COMMENT field (for eQSL submissions)
when working weak signal and other modes with auto logging enabled?

CREATE TRIGGER [INSQSLMSG]
AFTER INSERT
ON [Log]
FOR EACH ROW
WHEN (NEW.QSLMSG='') AND (NEW.COMMENT<>'')
BEGIN
UPDATE LOG
SET QSLMSG=SUBSTR(COMMENT,0,300)
WHERE QSOID=NEW.QSOID;
END

This will populate the qslmsg field when it's empty and when COMMENT is populated.
Alan
Post Reply