Re: need help with sql filter

Jamie WW3S

thanks Dave, that’s exactly what I needed....

-----Original Message-----
From: Dave AA6YQ
Sent: Sunday, October 21, 2012 3:11 PM
To: dxlab@...
Subject: RE: [dxlab] need help with sql filter

AA6YQ comments below
-----Original Message-----
From: dxlab@... [mailto:dxlab@...]On Behalf Of
Jamie WW3S
Sent: Sunday, October 21, 2012 2:53 PM
To: dxlab@...
Subject: [dxlab] need help with sql filter

I screwed something up, I knew I should have backed up the log before I started....I think I can recover what I’m after. I need a SQL filter to show the QSL date received is populated with anything, and qsl sent is that possible?

If you mean filter the log page display to show all QSOs whose "Date Rcvd" item is non-empty and use "Date Sent" item is empty, then use
(qslrdate<>#4000-01-01#) and (qslsdate=#4000-01-01#)

In DXKeeper, 4000-01-01 is used to represent an unspecified date. Any of a QSO's date items that contain 4000-01-01 are displayed as being empty.

Dave, AA6YQ


Yahoo! Groups Links

No virus found in this message.
Checked by AVG -
Version: 2013.0.2740 / Virus Database: 2601/5829 - Release Date: 10/13/12
Internal Virus Database is out of date.

Join to automatically receive all group messages.