Excellent SQL power -- love this

1 post / 0 new
KL2ZZ
Excellent SQL power -- love this

I just migrated to CQRLog from Xlog, and I'm loving the power of this tool.  After import, I realized that my adif file had reversed the RST values, so that the valued I'd reported out was in the column for values coming in.  No problem:

 

UPDATE view_cqrlog_main_by_qsodate SET rst_r=rst_s, rst_s=@temp WHERE (@temp:=rst_r) IS NOT NULL;

 

and all of my RST values were swapped.  I would have had to have to swap the values for each QSO using my old logging program.  Very pleased.