However I got it myself, took me some times, but now it works fine !
should be like this: log.Country = 'Japan' AND (log.mode = 'JT65' OR log.mode = 'JT9')
I did not use the parentheses: (log.mode = 'JT65' OR log.mode = 'JT9')
At > search parameter >Simple if I combine Country-Mode1-Mode2 no result only one mode is ok,
it seems a singel OR or a singel AND command is needed, to get the country and the requested 2 different modes out.
Well, I am a SQLite dummy, sorry for my question !
Perhaps it may help some others as well !
73 Hans DF2MC
Help/Advice on using Custom searches
- IW3HMH
- Site Admin
- Posts: 2927
- Joined: 21 Jan 2013, 14:20
- Location: Quarto d'Altino - Venezia (ITA)
- Contact:
Re: Help/Advice on using Custom searches
your query:
Country = 'Japan' AND Mode = 'JT9' OR Mode = 'JT65'
The OR in jt65 works with "japan and jt9) screwing up your results
correct query:
Country = 'Japan' AND (Mode = 'JT9' OR Mode = 'JT65')
Country = 'Japan' AND Mode = 'JT9' OR Mode = 'JT65'
The OR in jt65 works with "japan and jt9) screwing up your results
correct query:
Country = 'Japan' AND (Mode = 'JT9' OR Mode = 'JT65')
Daniele Pistollato - IW3HMH