Date
1 - 3 of 3
DXK SQL Query Filter problem
|
If I try this on the bottom of the main log page, I get all the W1AW entries.
w1aw/* by Pressing the Call button.
But if I try either of these via the ADV Button as SQL's.
(CALL='W1AW/*')
(CALL='W1AW/*') AND (QSO_Begin BETWEEN #2023-03-01# and #2023-12-31#)
The header at top of DXKeeper shows:
"DXKeeper 17.0.7 - N8XI.mdb (filtered) no QSO's (N8XI)"
No QSO's show up in the Log...
TNX
73, Rick - N8XI
|
|
|
|
W9MR Mike
Change your = sign to the LIKE operator. Using the equal sign you're telling it you want it to read that exact string, instead of using the asterisk as a wildcard. (CALL LIKE 'W1AW/*')
(CALL LIKE 'W1AW/*') AND (QSO_Begin BETWEEN #2023-03-01# and #2023-12-31#) 73, Mike W9MR On Wed, Mar 29, 2023 at 9:39 AM Rick Arzadon - N8XI via groups.io <n8xi_1=yahoo.com@groups.io> wrote:
|
|
|
|
|
|
|