Re: Request for help: SQL Expression to find K1FOC 2021 QSO's in W1EBM log


John Etling
 

CHECK -- "Home  Station (K1FOC)”

 

You have 2 spaces between Home and Station.

 

Just a quick look see… that caught my attention.

 

 

73 de K3JAE

JOHN A. ETLING

 

Email: k3jae@...

Benton County, TN ARES EC

AF MARS: AFA4WO

 

 

 

 

From: DXLab@groups.io <DXLab@groups.io> On Behalf Of Gary Smetana
Sent: Friday, January 21, 2022 11:37 AM
To: DXLab <dxlab@groups.io>
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  

       Added Location.

  

#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...?



73,

Gary W1EBM

 

 

 

 

 

Join DXLab@groups.io to automatically receive all group messages.