I sent a big file to esql by uploading to the site from outside cqrlog. now I need to mark the qso records as sent to eqsl. I tried the following sql statement but nothing happens not even errors.
UPDATE cqrlog_main
SET eqsl_qsl_sent = 'Y', eqsl_qslsdate = '2012-04-27'
WHERE (eqsl_qsl_sent <> 'Y')
can somebody tell me what am I doing wrong.
thanks
Ray 9h1ej
From the main logger page.
Click file: then click show qso list.
Click Filter: Click Create,
Set the filter date, as follows,
From, your first qso in the log, I became a Ham in 2006, so I set the From date to 2006-01-01
then To: Current date, like today, then click filter.
Now click file: and then group edit.
Filed: EQSL sent
Vlaue: Y
Then click Apply, all done... 73 GDX my friend de K8WDX!!
Tom K8WDX
Thanks Tom, Tried it and works fine. Thanks for your halp.
73 ray
Hi Ray,
you SQL query looks fine. Did you refsh QSO in QSO list after that?
Tom, K8WDX described much more comfortable way how to do what you need.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Thanks for answering. I tried the way suggested by Tom and works fine, but I am still curious why the sql did not work. I did refresh and also exited the program and reloaded to see if the fields changed. The sql was doing something as it did give an execution time of a few seconds at the bottom when i hit run. anyway thanks for answering and for a very nice program.
73 Ray