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
COMMENT->eQSL.qslmsg Trigger
Return to “Feature suggestions”
Jump to
- News
- ↳ Country & Special Callsign file updates
- Log4OM v2
- ↳ FAQ
- ↳ General discussions
- ↳ User support
- ↳ Error reports
- ↳ Feature suggestions
- ↳ Country (LANGUAGE) Forum
- ↳ German language forum
- ↳ Spanish language forum
- ↳ Portuguese language forum
- ↳ French language forum
- ↳ Italian language forum
- ↳ Award Support
- Log4OM v1
- ↳ User Support
- ↳ General discussions
- ↳ Country (LANGUAGE) Forum
- ↳ German language forum
- ↳ Italian language forum
- ↳ Portuguese language forum
- ↳ Spanish language forum
- ↳ French language forum
- ↳ Software Integration
- ↳ SDR & VSP
- ↳ Feature suggestions
- ↳ Award support
- ↳ FAQ
- ↳ Error Reports
- ↳ Technical Information
- ↳ Send data to Log4OM
- ↳ Receive data from Log4OM
- ↳ Databases Etc.