Hello-
Ive had 2 instances of a qso coming from fldigi with the wrong date.
It seems to occur around 0000 utc. The date in CQRLOG is yesterday UTC date, instead of UTC today.
Any solution?
By the way really enjoying program otherwise!!! works well.
Thanks Dan kc2sta
Hi Dan,
please enable debug mode and try to send QSO from fldigi again. In cosole, you should see what is sending. Please post it here. Thank you.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
OK enabled debug mode. Deleted the N7 qso with wrong date in CQRLOG.
But N7 qso will not resend from fldigi. I then manually entered a qso into the fldigi logbook. This will not import either. So I made a real qso in fldigi (GM0SDV), it imported fine, the test qso and the N7 qso I was trying to pull in again would not come over.
CQRLOG had fldigi set for remote mode. Under fldigi preferences qso are set in import every 2 seconds.
here is the terminal output:
[WARNING] Out of OEM specific VK codes, changing to unassigned
[WARNING] Out of unassigned VK codes, assigning $FF
IniFile:/home/dan/cqrlog/log_data/cqrlog.cfg
Starting CQRLOG ...
SELECT * FROM version
SELECT * FROM cqrlog_main ORDER BY qsodate DESC,time_on DESC
In inicializerig
Model:1
Port:/dev/ttyS0
Baudrate:9600
Databits:8
StopBits:1
Handshake:None
Parity:None
DTR:OFF
RTS:OFF
Poll:500
An error has occured setting the serial speed:9600
Reloading rig configuration
An error has occured setting the serial speed:9600
Loading window size a position (height|width|top|left):666|818|298|17
Section:frmPropagation
Loading window size a position (frmPropagation) (height|width|top|left):149|167|749|1022
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
SELECT * FROM profiles WHERE nr = 1
select locator from profiles where nr = 1
1-FN32BV;Glenville NY USA;FT450 dipoles;
SFI: 79
A: 4
K: 3 (21 nT)
GF: QUIET
SSN: 28
Time: 2025 UT 14 Jul 2010
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
SELECT * FROM profiles WHERE nr = 1
select locator from profiles where nr = 1
1-FN32BV;Glenville NY USA;FT450 dipoles;
SELECT * FROM cqrlog_main ORDER BY qsodate DESC,time_on DESC
SELECT COUNT (*) FROM bandcn WHERE prefix not like '%*'
select count(*) from bandcn where
((F160 = 'Q') OR
(F137 = 'Q') OR (C137 = 'Q') OR (D137 = 'Q') OR
(C160 = 'Q') OR (D160 = 'Q') OR (F80 = 'Q') OR
(C80 = 'Q') OR (D80 = 'Q') OR (F40 = 'Q') OR
(C60 = 'Q') OR (D60 = 'Q') OR (F60 = 'Q') OR
(C40 = 'Q') OR (D40 = 'Q') OR (F30 = 'Q') OR
(C30 = 'Q') OR (D30 = 'Q') OR (F20 = 'Q') OR
(C20 = 'Q') OR (D20 = 'Q') OR (F17 = 'Q') OR
(C17 = 'Q') OR (D17 = 'Q') OR (F15 = 'Q') OR
(C15 = 'Q') OR (D15 = 'Q') OR (F12 = 'Q') OR
(C12 = 'Q') OR (D12 = 'Q') OR (F10 = 'Q') OR
(C10 = 'Q') OR (D10 = 'Q') OR (F6 = 'Q') OR
(C6 = 'Q') OR (D6 = 'Q') OR (F2 = 'Q') OR
(F4 = 'Q') OR (C4 = 'Q') OR (D4 = 'Q') OR
(C2 = 'Q') OR (D2 = 'Q') OR (F70 = 'Q') OR
(C70 = 'Q') OR (D70 = 'Q') OR (F1300 = 'Q') OR
(C220 = 'Q') OR (D220 = 'Q') OR (F220 = 'Q') OR
(C1300 = 'Q') OR (D1300 = 'Q') OR (F2450 = 'Q') OR
(C2450 = 'Q') OR (D2450 = 'Q') OR (F3475 = 'Q') OR
(C3475 = 'Q') OR (D3475 = 'Q') OR (F5850 = 'Q') OR
(C5850 = 'Q') OR (D5850 = 'Q') OR (F10500 = 'Q') OR
(C10500 = 'Q') OR (D10500 = 'Q') OR (F24250 = 'Q') OR
(C24250 = 'Q') OR (D24250 = 'Q') OR (F47200 = 'Q') OR
(C47200 = 'Q') OR (D47200 = 'Q') OR (F84000 = 'Q') OR
(C84000 = 'Q') OR (D84000 = 'Q') OR
(F900 ='Q') OR (C900='Q') OR (D900='Q')
)
and prefix not like '%*'
SFI: 79
A: 4
K: 3 (21 nT)
GF: QUIET
SSN: 28
Time: 2025 UT 14 Jul 2010
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
SELECT * FROM profiles WHERE nr = 1
select locator from profiles where nr = 1
1-FN32BV;Glenville NY USA;FT450 dipoles;
Type : 88 Text : program:fldigi v 3.12.5version:1date:14 Jul 2010time:2054endtime:2056call:GM0SDVmhz:14.072203mode:PSK31tx:rx:name:Victorqth:Hamiltonstate:province:country:Scotlandlocator:IO75WSserialout:serialin:free1:notes:power:25
mhz:14.072203
mode:PSK31
Call:GM0SDV
SELECT * FROM cqrlog_main WHERE call = 'GM0SDV' ORDER BY qsodate,time_on
select 1 as aa from RDB$DATABASE where exists (SELECT 1 from cqrlog_main where band = '20' and mode='PSK31' and qsl_s<>''
and dxcc_ref='GM')
select * from qslmgr where (call = 'GM0SDV') and fromDate <= cast('2010-07-14' as date) order by cast(fromDate as date)
SELECT iota_nr,pref FROM iota_list WHERE dxcc_ref = 'GM' ORDER BY iota_nr
select first(1)* from award1 where clubcall = 'GM0SDV' and frmdate <= cast('2010-07-14' as date) and todate >= cast('2010-07-14' as date)
Time on:2054
Time off:2056
Name:Victor
qth:Hamilton
loc:IO75WS
rst_r:
rst_r:
state:
note:
Note:
insert into cqrlog_main (qsodate,time_on,time_off,call,freq,mode,rst_s,rst_r,name,qth,qsl_s,qsl_r,qsl_via,iota,pwr,itu,waz,loc,my_loc,county,award,remarks,dxcc_ref,idcall,state,qso_dxcc,band,profile,cont) values('2010-07-14','20:54','20:56','GM0SDV',14.0722,'PSK31','599','599','Victor','Hamilton','','','RW6HS','','25 W',27,14,'IO75WS','FN32BV','','','','GM','GM0SDV','',1,'20',1,'EU')
Start in SaveDXCC
SELECT FIRST(1)* FROM bandcn WHERE prefix = 'GM'
UPDATE bandcn SET D20 = 'X' WHERE prefix = 'GM'
End in SaveDXCC
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
select locator from profiles where nr = 1
1-FN32BV;Glenville NY USA;FT450 dipoles;
SELECT * FROM cqrlog_main ORDER BY qsodate DESC,time_on DESC
SELECT * FROM cqrlog_main ORDER BY qsodate DESC,time_on DESC
SELECT COUNT (*) FROM bandcn WHERE prefix not like '%*'
select count(*) from bandcn where
((F160 = 'Q') OR
(F137 = 'Q') OR (C137 = 'Q') OR (D137 = 'Q') OR
(C160 = 'Q') OR (D160 = 'Q') OR (F80 = 'Q') OR
(C80 = 'Q') OR (D80 = 'Q') OR (F40 = 'Q') OR
(C60 = 'Q') OR (D60 = 'Q') OR (F60 = 'Q') OR
(C40 = 'Q') OR (D40 = 'Q') OR (F30 = 'Q') OR
(C30 = 'Q') OR (D30 = 'Q') OR (F20 = 'Q') OR
(C20 = 'Q') OR (D20 = 'Q') OR (F17 = 'Q') OR
(C17 = 'Q') OR (D17 = 'Q') OR (F15 = 'Q') OR
(C15 = 'Q') OR (D15 = 'Q') OR (F12 = 'Q') OR
(C12 = 'Q') OR (D12 = 'Q') OR (F10 = 'Q') OR
(C10 = 'Q') OR (D10 = 'Q') OR (F6 = 'Q') OR
(C6 = 'Q') OR (D6 = 'Q') OR (F2 = 'Q') OR
(F4 = 'Q') OR (C4 = 'Q') OR (D4 = 'Q') OR
(C2 = 'Q') OR (D2 = 'Q') OR (F70 = 'Q') OR
(C70 = 'Q') OR (D70 = 'Q') OR (F1300 = 'Q') OR
(C220 = 'Q') OR (D220 = 'Q') OR (F220 = 'Q') OR
(C1300 = 'Q') OR (D1300 = 'Q') OR (F2450 = 'Q') OR
(C2450 = 'Q') OR (D2450 = 'Q') OR (F3475 = 'Q') OR
(C3475 = 'Q') OR (D3475 = 'Q') OR (F5850 = 'Q') OR
(C5850 = 'Q') OR (D5850 = 'Q') OR (F10500 = 'Q') OR
(C10500 = 'Q') OR (D10500 = 'Q') OR (F24250 = 'Q') OR
(C24250 = 'Q') OR (D24250 = 'Q') OR (F47200 = 'Q') OR
(C47200 = 'Q') OR (D47200 = 'Q') OR (F84000 = 'Q') OR
(C84000 = 'Q') OR (D84000 = 'Q') OR
(F900 ='Q') OR (C900='Q') OR (D900='Q')
)
and prefix not like '%*'
In StripHTML ...
Grid:
State:
County:
qth: ,
SELECT COUNT (*) FROM bandcn WHERE prefix not like '%*'
select count(*) from bandcn where
((F160 = 'Q') OR
(F137 = 'Q') OR (C137 = 'Q') OR (D137 = 'Q') OR
(C160 = 'Q') OR (D160 = 'Q') OR (F80 = 'Q') OR
(C80 = 'Q') OR (D80 = 'Q') OR (F40 = 'Q') OR
(C60 = 'Q') OR (D60 = 'Q') OR (F60 = 'Q') OR
(C40 = 'Q') OR (D40 = 'Q') OR (F30 = 'Q') OR
(C30 = 'Q') OR (D30 = 'Q') OR (F20 = 'Q') OR
(C20 = 'Q') OR (D20 = 'Q') OR (F17 = 'Q') OR
(C17 = 'Q') OR (D17 = 'Q') OR (F15 = 'Q') OR
(C15 = 'Q') OR (D15 = 'Q') OR (F12 = 'Q') OR
(C12 = 'Q') OR (D12 = 'Q') OR (F10 = 'Q') OR
(C10 = 'Q') OR (D10 = 'Q') OR (F6 = 'Q') OR
(C6 = 'Q') OR (D6 = 'Q') OR (F2 = 'Q') OR
(F4 = 'Q') OR (C4 = 'Q') OR (D4 = 'Q') OR
(C2 = 'Q') OR (D2 = 'Q') OR (F70 = 'Q') OR
(C70 = 'Q') OR (D70 = 'Q') OR (F1300 = 'Q') OR
(C220 = 'Q') OR (D220 = 'Q') OR (F220 = 'Q') OR
(C1300 = 'Q') OR (D1300 = 'Q') OR (F2450 = 'Q') OR
(C2450 = 'Q') OR (D2450 = 'Q') OR (F3475 = 'Q') OR
(C3475 = 'Q') OR (D3475 = 'Q') OR (F5850 = 'Q') OR
(C5850 = 'Q') OR (D5850 = 'Q') OR (F10500 = 'Q') OR
(C10500 = 'Q') OR (D10500 = 'Q') OR (F24250 = 'Q') OR
(C24250 = 'Q') OR (D24250 = 'Q') OR (F47200 = 'Q') OR
(C47200 = 'Q') OR (D47200 = 'Q') OR (F84000 = 'Q') OR
(C84000 = 'Q') OR (D84000 = 'Q') OR
(F900 ='Q') OR (C900='Q') OR (D900='Q')
)
and prefix not like '%*'
SFI: 79
A: 4
K: 3 (21 nT)
GF: QUIET
SSN: 28
Time: 2025 UT 14 Jul 2010
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
select locator from profiles where nr = 1
1-FN32BV;Glenville NY USA;FT450 dipoles;
SELECT * FROM profiles ORDER BY nr
SELECT * FROM profiles WHERE nr = 1
SELECT * FROM cqrlog_main WHERE call = 'GM0SDV' ORDER BY qsodate,time_on
select * from qslmgr where (call = 'GM0SDV') and fromDate <= cast('2010-07-14' as date) order by cast(fromDate as date)
SELECT iota_nr,pref FROM iota_list WHERE dxcc_ref = 'GM' ORDER BY iota_nr
select first(1)* from award1 where clubcall = 'GM0SDV' and frmdate <= cast('2010-07-14' as date) and todate >= cast('2010-07-14' as date)
TCustomForm.SetActiveControl frmNewQSO:TfrmNewQSO AWinControl=edtCall:TEdit GetParentForm(AWinControl)=frmNewQSO:TfrmNewQSO csLoading=False AWinControl.CanFocus=False IsControlVisible=True Enabled=False
TApplication.HandleException Cannot focus a disabled or invisible window
Stack trace:
$0807DEDF
$0807B543
$08256748
$080DE586
$0809DA13
$081AB542
$08273358
$081AB342
$0825F81D
$082A077F
$082A0D65
$0830D39F
$082A061A
$0806A499
$08255F22
$082DBA77
$082CDEEB
Note:
UPDATE cqrlog_main set qsodate = '2010-07-14', time_on = '20:54', time_off = '20:56', call = 'GM0SDV', freq = 14.0722, mode = 'PSK31', rst_s = '599', rst_r = '599', qsl_s = '', qsl_r ='', qsl_via = 'RW6HS', iota = '', pwr = '25 W', waz = 14, itu = 27, loc = 'IO75WS', my_loc = 'FN32BV', county = '', remarks = 'test only not a real qso', dxcc_ref = 'GM', qso_dxcc = 1, name = 'Victor', qth = 'Hamilton', award = '', band = '20', profile = 1, idcall = 'GM0SDV', state='', cont = 'EU' where id_cqrlog = 10796
Start in DeleteDXCC
select 1 as aa from RDB$DATABASE where exists (select 1 from cqrlog_main where (dxcc_ref='GM') and ((not ((mode= 'SSB') or (mode='FM') or (mode='AM') or (mode='CW')))) and (band='20'))
DELETE FROM bandcn WHERE prefix='GM' AND (F160 IS NULL) AND
(F137 IS NULL) AND (C137 IS NULL) AND (D137 IS NULL) AND
(C160 IS NULL) AND (D160 IS NULL) AND (F80 IS NULL) AND
(C80 IS NULL) AND (D80 IS NULL) AND (F40 IS NULL) AND
(C60 IS NULL) AND (D60 IS NULL) AND (F60 IS NULL) AND
(C40 IS NULL) AND (D40 IS NULL) AND (F30 IS NULL) AND
(C30 IS NULL) AND (D30 IS NULL) AND (F20 IS NULL) AND
(C20 IS NULL) AND (D20 IS NULL) AND (F17 IS NULL) AND
(C17 IS NULL) AND (D17 IS NULL) AND (F15 IS NULL) AND
(C15 IS NULL) AND (D15 IS NULL) AND (F12 IS NULL) AND
(C12 IS NULL) AND (D12 IS NULL) AND (F10 IS NULL) AND
(C10 IS NULL) AND (D10 IS NULL) AND (F6 IS NULL) AND
(C6 IS NULL) AND (D6 IS NULL) AND (F2 IS NULL) AND
(C4 IS NULL) AND (D4 IS NULL) AND (F4 IS NULL) AND
(C2 IS NULL) AND (D2 IS NULL) AND (F70 IS NULL) AND
(C70 IS NULL) AND (D70 IS NULL) AND (F1300 IS NULL) AND
(C220 IS NULL) AND (D220 IS NULL) AND (F220 IS NULL) AND
(C1300 IS NULL) AND (D1300 IS NULL) AND (F2450 IS NULL) AND
(C2450 IS NULL) AND (D2450 IS NULL) AND (F3475 IS NULL) AND
(C3475 IS NULL) AND (D3475 IS NULL) AND (F5850 IS NULL) AND
(C5850 IS NULL) AND (D5850 IS NULL) AND (F10500 IS NULL) AND
(C10500 IS NULL) AND (D10500 IS NULL) AND (F24250 IS NULL) AND
(C24250 IS NULL) AND (D24250 IS NULL) AND (F47200 IS NULL) AND
(C47200 IS NULL) AND (D47200 IS NULL) AND (F84000 IS NULL) AND
(C84000 IS NULL) AND (D84000 IS NULL) AND (F900 IS NULL) AND
(C900 IS NULL) AND (D900 IS NULL)
AND (F160L IS NULL) AND
(F137L IS NULL) AND (C137L IS NULL) AND (D137L IS NULL) AND
(C160L IS NULL) AND (D160L IS NULL) AND (F80L IS NULL) AND
(C80L IS NULL) AND (D80L IS NULL) AND (F40L IS NULL) AND
(C40L IS NULL) AND (D40L IS NULL) AND (F30L IS NULL) AND
(C60L IS NULL) AND (D60L IS NULL) AND (F60L IS NULL) AND
(C30L IS NULL) AND (D30L IS NULL) AND (F20L IS NULL) AND
(C20L IS NULL) AND (D20L IS NULL) AND (F17L IS NULL) AND
(C17L IS NULL) AND (D17L IS NULL) AND (F15L IS NULL) AND
(C15L IS NULL) AND (D15L IS NULL) AND (F12L IS NULL) AND
(C12L IS NULL) AND (D12L IS NULL) AND (F10L IS NULL) AND
(C10L IS NULL) AND (D10L IS NULL) AND (F6L IS NULL) AND
(C6L IS NULL) AND (D6L IS NULL) AND (F2L IS NULL) AND
(C4L IS NULL) AND (D4L IS NULL) AND (F4L IS NULL) AND
(C2L IS NULL) AND (D2L IS NULL) AND (F70L IS NULL) AND
(C70L IS NULL) AND (D70L IS NULL) AND (F1300L IS NULL) AND
(C220L IS NULL) AND (D220L IS NULL) AND (F220L IS NULL) AND
(C1300L IS NULL) AND (D1300L IS NULL) AND (F2450L IS NULL) AND
(C2450L IS NULL) AND (D2450L IS NULL) AND (F3475L IS NULL) AND
(C3475L IS NULL) AND (D3475L IS NULL) AND (F5850L IS NULL) AND
(C5850L IS NULL) AND (D5850L IS NULL) AND (F10500L IS NULL) AND
(C10500L IS NULL) AND (D10500L IS NULL) AND (F24250L IS NULL) AND
(C24250L IS NULL) AND (D24250L IS NULL) AND (F47200L IS NULL) AND
(C47200L IS NULL) AND (D47200L IS NULL) AND (F84000L IS NULL) AND
(C84000L IS NULL) AND (D84000L IS NULL) AND (F900L IS NULL) AND
(C900L IS NULL) AND (D900L IS NULL);
End in DeleteDXCC
Start in SaveDXCC
SELECT FIRST(1)* FROM bandcn WHERE prefix = 'GM'
UPDATE bandcn SET D20 = 'X' WHERE prefix = 'GM'
End in SaveDXCC
SELECT * FROM cqrlog_main ORDER BY qsodate DESC,time_on DESC
SELECT COUNT (*) FROM bandcn WHERE prefix not like '%*'
select count(*) from bandcn where
((F160 = 'Q') OR
(F137 = 'Q') OR (C137 = 'Q') OR (D137 = 'Q') OR
(C160 = 'Q') OR (D160 = 'Q') OR (F80 = 'Q') OR
(C80 = 'Q') OR (D80 = 'Q') OR (F40 = 'Q') OR
(C60 = 'Q') OR (D60 = 'Q') OR (F60 = 'Q') OR
(C40 = 'Q') OR (D40 = 'Q') OR (F30 = 'Q') OR
(C30 = 'Q') OR (D30 = 'Q') OR (F20 = 'Q') OR
(C20 = 'Q') OR (D20 = 'Q') OR (F17 = 'Q') OR
(C17 = 'Q') OR (D17 = 'Q') OR (F15 = 'Q') OR
(C15 = 'Q') OR (D15 = 'Q') OR (F12 = 'Q') OR
(C12 = 'Q') OR (D12 = 'Q') OR (F10 = 'Q') OR
(C10 = 'Q') OR (D10 = 'Q') OR (F6 = 'Q') OR
(C6 = 'Q') OR (D6 = 'Q') OR (F2 = 'Q') OR
(F4 = 'Q') OR (C4 = 'Q') OR (D4 = 'Q') OR
(C2 = 'Q') OR (D2 = 'Q') OR (F70 = 'Q') OR
(C70 = 'Q') OR (D70 = 'Q') OR (F1300 = 'Q') OR
(C220 = 'Q') OR (D220 = 'Q') OR (F220 = 'Q') OR
(C1300 = 'Q') OR (D1300 = 'Q') OR (F2450 = 'Q') OR
(C2450 = 'Q') OR (D2450 = 'Q') OR (F3475 = 'Q') OR
(C3475 = 'Q') OR (D3475 = 'Q') OR (F5850 = 'Q') OR
(C5850 = 'Q') OR (D5850 = 'Q') OR (F10500 = 'Q') OR
(C10500 = 'Q') OR (D10500 = 'Q') OR (F24250 = 'Q') OR
(C24250 = 'Q') OR (D24250 = 'Q') OR (F47200 = 'Q') OR
(C47200 = 'Q') OR (D47200 = 'Q') OR (F84000 = 'Q') OR
(C84000 = 'Q') OR (D84000 = 'Q') OR
(F900 ='Q') OR (C900='Q') OR (D900='Q')
)
and prefix not like '%*'
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
select locator from profiles where nr = 1
1-FN32BV;Glenville NY USA;FT450 dipoles;
SELECT * FROM cqrlog_main ORDER BY qsodate DESC,time_on DESC
SELECT * FROM cqrlog_main ORDER BY qsodate DESC,time_on DESC
SELECT COUNT (*) FROM bandcn WHERE prefix not like '%*'
select count(*) from bandcn where
((F160 = 'Q') OR
(F137 = 'Q') OR (C137 = 'Q') OR (D137 = 'Q') OR
(C160 = 'Q') OR (D160 = 'Q') OR (F80 = 'Q') OR
(C80 = 'Q') OR (D80 = 'Q') OR (F40 = 'Q') OR
(C60 = 'Q') OR (D60 = 'Q') OR (F60 = 'Q') OR
(C40 = 'Q') OR (D40 = 'Q') OR (F30 = 'Q') OR
(C30 = 'Q') OR (D30 = 'Q') OR (F20 = 'Q') OR
(C20 = 'Q') OR (D20 = 'Q') OR (F17 = 'Q') OR
(C17 = 'Q') OR (D17 = 'Q') OR (F15 = 'Q') OR
(C15 = 'Q') OR (D15 = 'Q') OR (F12 = 'Q') OR
(C12 = 'Q') OR (D12 = 'Q') OR (F10 = 'Q') OR
(C10 = 'Q') OR (D10 = 'Q') OR (F6 = 'Q') OR
(C6 = 'Q') OR (D6 = 'Q') OR (F2 = 'Q') OR
(F4 = 'Q') OR (C4 = 'Q') OR (D4 = 'Q') OR
(C2 = 'Q') OR (D2 = 'Q') OR (F70 = 'Q') OR
(C70 = 'Q') OR (D70 = 'Q') OR (F1300 = 'Q') OR
(C220 = 'Q') OR (D220 = 'Q') OR (F220 = 'Q') OR
(C1300 = 'Q') OR (D1300 = 'Q') OR (F2450 = 'Q') OR
(C2450 = 'Q') OR (D2450 = 'Q') OR (F3475 = 'Q') OR
(C3475 = 'Q') OR (D3475 = 'Q') OR (F5850 = 'Q') OR
(C5850 = 'Q') OR (D5850 = 'Q') OR (F10500 = 'Q') OR
(C10500 = 'Q') OR (D10500 = 'Q') OR (F24250 = 'Q') OR
(C24250 = 'Q') OR (D24250 = 'Q') OR (F47200 = 'Q') OR
(C47200 = 'Q') OR (D47200 = 'Q') OR (F84000 = 'Q') OR
(C84000 = 'Q') OR (D84000 = 'Q') OR
(F900 ='Q') OR (C900='Q') OR (D900='Q')
)
and prefix not like '%*'
SELECT COUNT (*) FROM bandcn WHERE prefix not like '%*'
select count(*) from bandcn where
((F160 = 'Q') OR
(F137 = 'Q') OR (C137 = 'Q') OR (D137 = 'Q') OR
(C160 = 'Q') OR (D160 = 'Q') OR (F80 = 'Q') OR
(C80 = 'Q') OR (D80 = 'Q') OR (F40 = 'Q') OR
(C60 = 'Q') OR (D60 = 'Q') OR (F60 = 'Q') OR
(C40 = 'Q') OR (D40 = 'Q') OR (F30 = 'Q') OR
(C30 = 'Q') OR (D30 = 'Q') OR (F20 = 'Q') OR
(C20 = 'Q') OR (D20 = 'Q') OR (F17 = 'Q') OR
(C17 = 'Q') OR (D17 = 'Q') OR (F15 = 'Q') OR
(C15 = 'Q') OR (D15 = 'Q') OR (F12 = 'Q') OR
(C12 = 'Q') OR (D12 = 'Q') OR (F10 = 'Q') OR
(C10 = 'Q') OR (D10 = 'Q') OR (F6 = 'Q') OR
(C6 = 'Q') OR (D6 = 'Q') OR (F2 = 'Q') OR
(F4 = 'Q') OR (C4 = 'Q') OR (D4 = 'Q') OR
(C2 = 'Q') OR (D2 = 'Q') OR (F70 = 'Q') OR
(C70 = 'Q') OR (D70 = 'Q') OR (F1300 = 'Q') OR
(C220 = 'Q') OR (D220 = 'Q') OR (F220 = 'Q') OR
(C1300 = 'Q') OR (D1300 = 'Q') OR (F2450 = 'Q') OR
(C2450 = 'Q') OR (D2450 = 'Q') OR (F3475 = 'Q') OR
(C3475 = 'Q') OR (D3475 = 'Q') OR (F5850 = 'Q') OR
(C5850 = 'Q') OR (D5850 = 'Q') OR (F10500 = 'Q') OR
(C10500 = 'Q') OR (D10500 = 'Q') OR (F24250 = 'Q') OR
(C24250 = 'Q') OR (D24250 = 'Q') OR (F47200 = 'Q') OR
(C47200 = 'Q') OR (D47200 = 'Q') OR (F84000 = 'Q') OR
(C84000 = 'Q') OR (D84000 = 'Q') OR
(F900 ='Q') OR (C900='Q') OR (D900='Q')
)
and prefix not like '%*'
SELECT * FROM cqrlog_main ORDER BY qsodate DESC,time_on DESC
SELECT * FROM cqrlog_main ORDER BY qsodate DESC,time_on DESC
SELECT COUNT (*) FROM bandcn WHERE prefix not like '%*'
select count(*) from bandcn where
((F160 = 'Q') OR
(F137 = 'Q') OR (C137 = 'Q') OR (D137 = 'Q') OR
(C160 = 'Q') OR (D160 = 'Q') OR (F80 = 'Q') OR
(C80 = 'Q') OR (D80 = 'Q') OR (F40 = 'Q') OR
(C60 = 'Q') OR (D60 = 'Q') OR (F60 = 'Q') OR
(C40 = 'Q') OR (D40 = 'Q') OR (F30 = 'Q') OR
(C30 = 'Q') OR (D30 = 'Q') OR (F20 = 'Q') OR
(C20 = 'Q') OR (D20 = 'Q') OR (F17 = 'Q') OR
(C17 = 'Q') OR (D17 = 'Q') OR (F15 = 'Q') OR
(C15 = 'Q') OR (D15 = 'Q') OR (F12 = 'Q') OR
(C12 = 'Q') OR (D12 = 'Q') OR (F10 = 'Q') OR
(C10 = 'Q') OR (D10 = 'Q') OR (F6 = 'Q') OR
(C6 = 'Q') OR (D6 = 'Q') OR (F2 = 'Q') OR
(F4 = 'Q') OR (C4 = 'Q') OR (D4 = 'Q') OR
(C2 = 'Q') OR (D2 = 'Q') OR (F70 = 'Q') OR
(C70 = 'Q') OR (D70 = 'Q') OR (F1300 = 'Q') OR
(C220 = 'Q') OR (D220 = 'Q') OR (F220 = 'Q') OR
(C1300 = 'Q') OR (D1300 = 'Q') OR (F2450 = 'Q') OR
(C2450 = 'Q') OR (D2450 = 'Q') OR (F3475 = 'Q') OR
(C3475 = 'Q') OR (D3475 = 'Q') OR (F5850 = 'Q') OR
(C5850 = 'Q') OR (D5850 = 'Q') OR (F10500 = 'Q') OR
(C10500 = 'Q') OR (D10500 = 'Q') OR (F24250 = 'Q') OR
(C24250 = 'Q') OR (D24250 = 'Q') OR (F47200 = 'Q') OR
(C47200 = 'Q') OR (D47200 = 'Q') OR (F84000 = 'Q') OR
(C84000 = 'Q') OR (D84000 = 'Q') OR
(F900 ='Q') OR (C900='Q') OR (D900='Q')
)
and prefix not like '%*'
SELECT COUNT (*) FROM bandcn WHERE prefix not like '%*'
select count(*) from bandcn where
((F160 = 'Q') OR
(F137 = 'Q') OR (C137 = 'Q') OR (D137 = 'Q') OR
(C160 = 'Q') OR (D160 = 'Q') OR (F80 = 'Q') OR
(C80 = 'Q') OR (D80 = 'Q') OR (F40 = 'Q') OR
(C60 = 'Q') OR (D60 = 'Q') OR (F60 = 'Q') OR
(C40 = 'Q') OR (D40 = 'Q') OR (F30 = 'Q') OR
(C30 = 'Q') OR (D30 = 'Q') OR (F20 = 'Q') OR
(C20 = 'Q') OR (D20 = 'Q') OR (F17 = 'Q') OR
(C17 = 'Q') OR (D17 = 'Q') OR (F15 = 'Q') OR
(C15 = 'Q') OR (D15 = 'Q') OR (F12 = 'Q') OR
(C12 = 'Q') OR (D12 = 'Q') OR (F10 = 'Q') OR
(C10 = 'Q') OR (D10 = 'Q') OR (F6 = 'Q') OR
(C6 = 'Q') OR (D6 = 'Q') OR (F2 = 'Q') OR
(F4 = 'Q') OR (C4 = 'Q') OR (D4 = 'Q') OR
(C2 = 'Q') OR (D2 = 'Q') OR (F70 = 'Q') OR
(C70 = 'Q') OR (D70 = 'Q') OR (F1300 = 'Q') OR
(C220 = 'Q') OR (D220 = 'Q') OR (F220 = 'Q') OR
(C1300 = 'Q') OR (D1300 = 'Q') OR (F2450 = 'Q') OR
(C2450 = 'Q') OR (D2450 = 'Q') OR (F3475 = 'Q') OR
(C3475 = 'Q') OR (D3475 = 'Q') OR (F5850 = 'Q') OR
(C5850 = 'Q') OR (D5850 = 'Q') OR (F10500 = 'Q') OR
(C10500 = 'Q') OR (D10500 = 'Q') OR (F24250 = 'Q') OR
(C24250 = 'Q') OR (D24250 = 'Q') OR (F47200 = 'Q') OR
(C47200 = 'Q') OR (D47200 = 'Q') OR (F84000 = 'Q') OR
(C84000 = 'Q') OR (D84000 = 'Q') OR
(F900 ='Q') OR (C900='Q') OR (D900='Q')
)
and prefix not like '%*'
SFI: 79
A: 4
K: 3 (21 nT)
GF: QUIET
SSN: 28
Time: 2025 UT 14 Jul 2010
===============================
So I am curious how to force the qso from Fldigi. I tried, rebooting both programs, resetting remote mode, refresh data.
I did have a prior real qso not move over, I had to manually enter it to CQRLOG, that happened once.
Thanks Dan
Dan KC2STA