Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to add the country in the logbook column
29-08-2025, 02:50 PM, (This post was last modified: 29-08-2025, 02:53 PM by F6AUE.)
#1
how to add the country in the logbook column
Hello, 
I am trying to understand how to insert the country field of the contacted call into the logbook. I saw that the country field was in the Address table. How do I link this field to the QSO table in order to have it in the logbook?
 Thank you for your help.
Reply
29-08-2025, 03:12 PM, (This post was last modified: 29-08-2025, 03:15 PM by EA3GCV.)
#2
RE: how to add the country in the logbook column
Hello,

The country name field is in the INF_DXCC table. You need to add the INF_DXCC table then join the DXCC field from the QSO table to the DXCC field of the INF_DXCC table. The join must be "Return all records from the QSO table and only matching records from the INF_DXCC table". Otherwise you won't see listed all QSOs with a blank DXCC (such as all /MM QSO). Then add the DXCC_NAME field from the INF_DXCC table to the query.

If you edit any of the queries included in the Queries\DXCC folder you will see an example of this link. IMPORTANT: in these queries the join is just the opposite! return all records from INF_DXCC and only matching from QSO.

73
Jordi, EA3GCV
Current developer of Swisslog
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)