COMMENT->eQSL.qslmsg Trigger
Posted: 26 Apr 2021, 01:47
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
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