Re: Request for help: SQL Expression to find K1FOC 2021 QSO's in W1EBM log
toggle quoted messageShow quoted text
CHECK -- "Home Station (K1FOC)”
You have 2 spaces between Home and Station.
Just a quick look see… that caught my attention.
From: DXLab@groups.io <DXLab@groups.io> On Behalf Of Gary Smetana
Sent: Friday, January 21, 2022 11:37 AM
To: DXLab <email@example.com>
Subject: [DXLab] Request for help: SQL Expression to find K1FOC 2021 QSO's in W1EBM log
Hi Dave & the Group,
Need some help. Think my SQL's not quite right.
Here’s the steps I did :
#1) Created (in ADV window, in Filter #1 at bottom: an SQL User-Defined Sort as:
(STATION_CALLSIGN='K1FOC') AND (QSO_ Begin >#2021-01-01 00:00#)
#2) In TQSL, I confirmed I had added "Home Station (K1FOC)” as an
#3) In Main Window, clicked on QSL; then clicked “QSL Config.”
#4) In the new window, selected the LoTW tab. In the TQSL area @
bottom, I changed the "Station Location” to "Home Station (K1FOC)”
and changed the "Station Call Sign" to K1FOC.
#5) Clicked on "Filter"
#6) Get Error Message: "Invalid Filter Expression"
Got a bad character or a missing character...?