DXCC change of USA from W(USA) to W is causing me problems

3 posts / 0 new

Sun, 2010-08-15 01:04

KC2STA

Hello ---

I am having problems filtering logs for USA. I noticed they worked in old saved filters, but not new filters. Also the WAS report is not functioning correct, logs I just entered would not show up.

I traced the problem to the DXCC designation for USA. It used to be W (USA), now it is W. Not sure when it was changed but problem stated past week.

That is why old saved filters and older logs filter fine and show up on WAS (using W (USA)), and newer logs using W don't.

I noticed if I opened a log it would update itself to W from W (USA), but then it drops off the WAS list.

Same if I rebuild DXCC statistics, the WAS list loses all data because all logs now say W but WAS list must be looking for W(USA)

Any fix at my end?

Thanks Dan

Tue, 2010-08-17 11:06

KC2STA

I ran in debug mode and here

I ran in debug mode and here is what it says for WAS--

select distinct state,band,qsl_r from cqrlog_main where (state <> '') and ((dxcc_ref='W(USA)') or (dxcc_ref='KL') or (dxcc_ref='KH6')) and (mode = 'CW') AND (profile = 1) order by state

so need to add (dxcc_ref='W').

where in code can I do that?

Thanks Dan

Dan KC2STA