logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

ALERT FORM FILTERS
K7PDW
#1 Posted : Thursday, July 28, 2016 3:52:40 PM(UTC)
DAVE

Rank: Advanced Member

Groups: Registered
Posts: 85
Man
Location: Syracuse, Utah

Thanks: 21 times
Was thanked: 13 time(s) in 12 post(s)
I want to set up a filter in the alert setup form for multiple call prefixes. I can't figure out the format and the wizard does not help either. I want the filter to catch a list. For example:

CALL=K5, K6, K7, W5, W6 ,W7, N5, N6, N7, VA, VE, U4

I've tried direct entry (CALL='K5','K6','K7') No good.
The wizard yields CALL='K5,K6,K7' for wizard entry K5,K6,K7 No good. Also tried spaces between. Still no good.
Tried 'K5','K6','K7'. Wizard yields CALL="'K5','K6','K7'" Yep still no good.

It does work with the following filter.

CALL='K5' OR CALL='K6' OR CALL='K7' OR CALL='W5' OR CALL='W6' OR CALL='W7' OR CALL='VA' OR CALL='VE' OR CALL='4U'

However, it would be easier to create filters for such things as CQ zone where many prefixes need to be filtered, if some sort of compounding were available.

Can anyone help?


Dave, K7PDW
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
vk4iu
#2 Posted : Thursday, July 28, 2016 7:02:24 PM(UTC)
VK4IU

Rank: Advanced Member

Groups: Moderator, Registered, Administrators
Posts: 404
Man
Location: Hodgleigh QLD

Thanks: 6 times
Was thanked: 77 time(s) in 68 post(s)
G'Day Dave,

You need to comply with the "syntax" of the language in use - in this case Microsoft's Visual Foxpro. Search the Internet for the correct syntax.

You could use the "contains" operator. But you would need to create the test yourself, rather than use the filter's QBE. Click EDIT to modify the filter and change the test around.

That is

LEFT(CALL,2) $ "K5,K6,K7"

or

CQ_ZONE $ "30,31,32"

If you are so inclined you can write your own "user functions" to be executed by LOGic on your behalf. The sky is the limit.

See http://www.hosenose.com/forum/yaf_postst1130_Personal-function---spot-alerts.aspx

Peter VK4IU
You can help by posting images of any errors and including your Logic version.
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.024 seconds.