Search found 37 matches
- Tue Mar 05, 2013 5:22 am
- Forum: Hints and Tips
- Topic: SQL hints
- Replies: 7
- Views: 28039
SQL hints
<t>Greetings WinLog32 users,<br/> <br/> I continue to play with some SQL and thought I would share the results for those interested. Check for date formats but other than that I think the following work fine: (Some of these may be handled by the program itself instead of a search but if you use the ...
- Tue Mar 05, 2013 5:22 am
- Forum: Hints and Tips
- Topic: SQL hints
- Replies: 7
- Views: 28039
SQL hints
<t>Colin,<br/> <br/> Thanks and yes I have played with the plug-ins feature. However, I often do searches to look for "how many..." When I have tried the plug-in feature I can't seem to see the totals anyplace? For example, in the case I am not explaining very well: When I do a search in the search ...
- Tue Mar 05, 2013 5:22 am
- Forum: Hints and Tips
- Topic: SQL hints
- Replies: 7
- Views: 28039
SQL hints
<t>Colin - when that happens I will be happy on several and share them.<br/> <br/> Gary, N5PHT<br/> <br/> quote:Originally posted by G0CUZ<br/> <br/> Hi Gary<br/> <br/> Good point about the editor and counting the records, as you say - it doesn't seem to give a total and this would be useful.<br/> <...
- Tue Mar 05, 2013 5:22 am
- Forum: Hints and Tips
- Topic: SQL hints
- Replies: 7
- Views: 28039
SQL hints
<r>Another SQL goodie: (help from Andrew Cumming at <URL url="http://sqlzoo.net">http://sqlzoo.net</URL>):<br/> <br/> To get a count for how many qso per day over a range - or for that matter it will tell you how many days of the past whatever range you have at least one qso. (I know some CW folks t...
- Tue Mar 05, 2013 5:22 am
- Forum: Hints and Tips
- Topic: SQL hints
- Replies: 7
- Views: 28039
SQL hints
<t>Another SQL (again, with assistance from Andrew at sqlzoo.net)<br/> <br/> This is a neat search if you are interested to know how many qsos you have made per month over any period of time. I used it to check how many qsos I have made each month since being licensed in 1986. The result is a list b...
- Tue Mar 05, 2013 5:17 am
- Forum: Help and Support
- Topic: SQL hints
- Replies: 0
- Views: 7185
SQL hints
<t>I have found another SQL that works well for searching the log for hams that I have had over 'x' qsos with over the years! Neat as I have been trying to find that out for awhile.<br/> <br/> This works: (30 qsos in this example)<br/> <br/> SELECT callsign,COUNT(*) FROM log<br/> GROUP BY callsign H...
- Mon Mar 04, 2013 4:03 am
- Forum: Feature Requests
- Topic: Unique Callsigns (sql?)
- Replies: 3
- Views: 4918
Unique Callsigns (sql?)
<t>I would love to have a way to know how many unique callsigns are in my log. I know some dx'pedition software has this but I have not found one yet that I can get to work. It may be possible through a SQL search? Or through Excell formulas but I have tried there and no success also but I am no exp...
- Mon Mar 04, 2013 4:03 am
- Forum: Feature Requests
- Topic: Unique Callsigns (sql?)
- Replies: 3
- Views: 4918
Unique Callsigns (sql?)
<t>I have the answer. Started to delete the post but in case others want to find unique callsigns it is a simple 5 word SQL:<br/> <br/> SELECT DISTINCT callsign FROM LOG<br/> <br/> Worked FB to show that I have 26,895 unique callsigns in my log of about 52,000 entries.<br/> <br/> Excellent - been tr...
- Mon Mar 04, 2013 4:03 am
- Forum: Feature Requests
- Topic: Unique Callsigns (sql?)
- Replies: 3
- Views: 4918
Unique Callsigns (sql?)
<t>Yes Colin,<br/> <br/> SQL has really caught my interest. I am now working on another SQL that I have wanted for a long time. I would like to be able to search for callsigns of hams that I have worked over x number of times. I am playing with the SQL for that with COUNT etc but have yet to get it ...
- Sun Mar 03, 2013 6:05 am
- Forum: Feature Requests
- Topic: Contest Logging
- Replies: 7
- Views: 7708
Contest Logging
<t>Colin,<br/> <br/> I am using only Laptop and will test when released.<br/> <br/> Gary, N5PHT<br/> <br/> quote:Originally posted by G0CUZ<br/> <br/> Hi Guys<br/> <br/> Just need to finish up a couple of other things, and check this scrolling report idea on another machine, also have a prefix updat...