CQ code incorrect, how to change in qso data?

[NN7D]

Hi,
I messed up my CQ code when first installing the program. Now I have corrected CQ code in Station Info, then restarted the program, but previously logged QSO's still have the incorrect code, even for ADIF export. I can view the code via Recent QSO (F7) display because I added that field (My CQ zone) to the display. But I can't find anyway to update the field in the qso data. Must I get into the SQLLite data to make the change?

I want to get this data correct before uploading to LofW.

Thanks!

Doug

[G4POP]

In QSO Archive manager

1. Check Enable update
2. Select the QSO's to be changed
3. Click "Field update' button
4. Select "My CQ Zone" from the "Field to update" list
5. Enter correct zone in the "Value" field
6. Click the "Update" button

You could watch the video here http://www.youtube.com/watch?v=aLXQwM-2uQ0

also see screen shot below

[NN7D]

Ah ha! Thank you Terry. I had not reviewed that section of the very well written manual yet! You folks have thought about almost everything! That should do the job.

Thanks much for your help!

Doug

[IW3HMH]

Terry explained the "classic" way to update a log.

If you're a "nerd" and you want more "control" on your data you can also updating the log using the "query" field on the right side.

Table is called "log", field is MyCqZone

Code: Select all

update log set MyCqZone = 5

should work well on the whole database

Remember to take a backup before!

73
Daniele

[NN7D]

Oh, I am a "nerd", all right. Retired from software development - Delphi nerd.

BTW, I just noticed where you are from Daniele, Venenzia! We were there last year on a one week cycling trip. Wonderful region!

Thanks much!

Doug

[N5INP]

I just did this too after reading, because my CQ code has not been correct (neither has the ITU). Seemed to work OK for all entries.

[NN7D]

I've made the changes. Worked out well. Did not expect such a nice data management feature! I keep being amazed at the program.

Thank you very much!

Doug

[IW3HMH]

Spread the word!!
lele

[N5INP]

Spread the word!!
lele

I am.

A local ham here in Ft. Worth was listening to me describe how I can click on the cluster listings in Log4OM and have my radio auto-magically tune to the listing freq. I spent the next hour helping him with questions he had to get this app installed.