I tried it again using different search parameters and used contacts without / , etc. Used W3LPL and 3B6CF where I have a number of QSOs both confirmed and not. The date order is completely random, regardless of the search parameters. I am using DXBase 2007.
I can't say that it is a huge inconvenience but it would be nice to find when there are a number of QQSOs with the station. Bill W5VX -----Original Message----- From: dxbase-boun...@mailman.qth.net [mailto:dxbase-boun...@mailman.qth.net] On Behalf Of Joe WA6AXE Sent: Sunday, August 01, 2010 8:20 PM To: a...@mtaonline.net; dxbase@mailman.qth.net Subject: [Dxbase] Previous QSO module DXb2006 versus 2007 Gary and all: Tryng to recall backwards by four years -- there is a difference between 2006 and 2007 -- the DXbase NOTES that came with 2007 state: Modified the Previous QSO module so that partial lookups for callsign, special-1, and special-2 fields will be performed. For example, entering AA4 will return all records containing AA4. Entering AA4LU will return all records that contain AA4LU such as AA4LU/P...HA/AA4LU, AA4LU, etc... Apparently during this mod is where the changes we are seeing took place. 73 Joe wa6axe > From: wa6...@hotmail.com > To: a...@mtaonline.net; dxbase@mailman.qth.net > Date: Sun, 1 Aug 2010 19:58:14 -0500 > Subject: Re: [Dxbase] Couple of items for next release > > > Gary and all: > > DXbase2006 Previous QSO window -- when you do a FIND of a PREFIX, the > listing is SORTED by Callsign (Ascending) and within Callsign - by date and time > (Ascending). > > DXbase2006 Previous QSO window - when you do a FIND of a Specific > CALLSIGN, the listing is SORTED by DATE/Time (Ascending). > > AND -- in DXbase2007 -- the FIND of a PREFIX - it is the SAME way as 2006 .. > > BUT - when you FIND by CALLSIGN -- My listing is SORTED by DATE/TIME ** (Descending) ** . > > > Joe wa6axe > > > > > From: a...@mtaonline.net > > To: dxbase@mailman.qth.net > > Date: Sun, 1 Aug 2010 16:34:10 -0800 > > Subject: Re: [Dxbase] Couple of items for next release > > > > In the "For What It's Worth" department, I've gotten back three replies so > > far that the Compact database action does not correct the sort sequence > > problem in the Previous QSO's window. All three are using DXB2007. So from > > this extremely small, unscientific survey, I'm going to go out on a limb and > > surmise that there IS a difference in how DXB2006 and DXB2007 respond to the > > Compact database utility. Probably the only hope is that Neal's new version > > will address the situation when it is released. > > > > 73, > > Gary AL9A > > > > > > ----- Original Message ----- > > From: "Gary AL9A" <a...@mtaonline.net> > > To: "Crownhaven" <crownha...@bellsouth.net>; <dxbase@mailman.qth.net> > > Sent: August 01, 2010 11:21 AM > > Subject: Re: [Dxbase] Couple of items for next release > > > > > > > Ok, now I'm curious. The Compact database works fine in DXBase2006 for > > > sorting the Previous QSO'S window. For those who have commented that this > > > doesn't work for you, what version of DXB are you running? I'm wondering > > > if > > > there is a difference between 2006 and 2007. > > > > > > 73, > > > Gary AL9A > > > > > > ----- Original Message ----- > > > From: "Crownhaven" <crownha...@bellsouth.net> > > > To: <dxbase@mailman.qth.net> > > > Sent: July 31, 2010 7:34 PM > > > Subject: Re: [Dxbase] Couple of items for next release > > > > > > > > >>I just went through the compacting database routine a second time and it > > >> didn't correct the date order of the QSOs listed in "previous QSOs." > > >> > > >> Steve, N4JQQ > > >> > > >> On 7/31/2010 9:44 PM, Tony wrote: > > >>> I am running DXBase 2007 and my Q's looked up in the Previous QSOs > > >>> window > > >>> are > > >>> NOT in any kind of order (just all mixed up as far as date is > > >>> concerned). > > >>> > > >>> 73 de Tony, KD4K > > >>> > > >>> > > >>> > > >>> -----Original Message----- > > >>> From: dxbase-boun...@mailman.qth.net > > >>> [mailto:dxbase-boun...@mailman.qth.net] > > >>> On Behalf Of Gary AL9A > > >>> Sent: Friday, July 30, 2010 2:14 AM > > >>> To: Joe Duerbusch; DXbase@mailman.qth.net > > >>> Subject: Re: [Dxbase] Couple of items for next release > > >>> > > >>> Hi Joe, > > >>> > > >>> Well that's surprising. I'm running DXB2006 and I just checked W7WA in > > >>> my > > >>> Previous QSO's window. I have quite a few contest Q's in my log and the > > >>> query showed the last contact as first in the list. All the others were > > >>> in > > >>> ascending order, but the last one was at the top of the list. I closed > > >>> my > > >>> database, made a backup and ran the Compact utility. When I restarted > > >>> and > > >>> checked W7WA again all QSO's were now in ascending order. Those on the > > >>> same > > >>> date were in ascending time order. Not sure why it works for me and not > > >>> you. > > >>> > > >>> 73, > > >>> Gary AL9A > > >>> > > >>> > > >>> ----- Original Message ----- > > >>> From: "Joe Duerbusch"<jduerbu...@sbcglobal.net> > > >>> To:<DXbase@mailman.qth.net> > > >>> Cc: "Gary AL9A"<a...@mtaonline.net>;<k...@arrl.net> > > >>> Sent: July 29, 2010 5:33 PM > > >>> Subject: Re: [Dxbase] Couple of items for next release > > >>> > > >>> > > >>> > > >>>> Hi Gary, thank you for you idea. I had just compacted my k0bx.mdb last > > >>>> week, but I did it again tonight. > > >>>> I then went to the Previous QSO window and put in AA5AU callisign. > > >>>> 166 QSO were found, first one in 1998 and the last in 2003. Of course > > >>>> there was difffernt years all through the list in all kinds of order. > > >>>> So > > >>>> that did not fix the problem. > > >>>> > > >>>> I am not going to second guest the DXbase programmer, but I have been > > >>>> write SQL queries in Access and other languages for years. I am > > >>>> currently > > >>>> > > >>> > > >>>> writing in JAVA with SQL to ORACLE databases for the Boeing Company. > > >>>> So adding a 'order by' clause is not a big deal. > > >>>> > > >>>> The k0bx.mdb table is sorted correctly by date and time, so there must > > >>>> be > > >>>> a join with another table that is messing up the sort order. > > >>>> > > >>>> Thanks again for you comments Gary. > > >>>> > > >>>> Joe K0BX > > >>>> > > >>>> Gary AL9A wrote: > > >>>> > > >>>> > > >>>>> Joe, > > >>>>> > > >>>>> The date order problem is not due to DXB per se, but the way Access > > >>>>> works. First make a backup of your mdb file. When your dates in the > > >>>>> Previous QSO window get out of order go to the DXBase folder on the > > >>>>> Start > > >>>>> > > >>> > > >>>>> menu and run the Dxbutility program. In the Dxbutility select > > >>>>> Database. > > >>>>> Make sure the path name points to your mdb file and click on the > > >>>>> Compact > > >>>>> button. This action removes old garbage file remnants that Access > > >>>>> leaves > > >>>>> > > >>> > > >>>>> behind and compacts your database to consume less hard drive space. > > >>>>> As > > >>>>> an extra bonus, when you now go to the Previous QSO's window you will > > >>>>> find the dates and times are correctly sorted in ascending order. I > > >>>>> can't explain why Access gets this messed up. Over time it just > > >>>>> happens > > >>>>> and Compacting the database corrects the problem. > > >>>>> > > >>>>> 73, > > >>>>> Gary AL9A > > >>>>> > > >>>>> > > >>>>> > > >>> ______________________________________________________________ > > >>> Dxbase mailing list > > >>> Home: http://mailman.qth.net/mailman/listinfo/dxbase > > >>> Help: http://mailman.qth.net/mmfaq.htm > > >>> Post: mailto:Dxbase@mailman.qth.net > > >>> > > >>> This list hosted by: http://www.qsl.net > > >>> Please help support this email list: http://www.qsl.net/donate.html > > >>> > > >>> > > >>> ______________________________________________________________ > > >>> Dxbase mailing list > > >>> Home: http://mailman.qth.net/mailman/listinfo/dxbase > > >>> Help: http://mailman.qth.net/mmfaq.htm > > >>> Post: mailto:Dxbase@mailman.qth.net > > >>> > > >>> This list hosted by: http://www.qsl.net > > >>> Please help support this email list: http://www.qsl.net/donate.html > > >>> > > >>> > > >>> > > >> ______________________________________________________________ > > >> Dxbase mailing list > > >> Home: http://mailman.qth.net/mailman/listinfo/dxbase > > >> Help: http://mailman.qth.net/mmfaq.htm > > >> Post: mailto:Dxbase@mailman.qth.net > > >> > > >> This list hosted by: http://www.qsl.net > > >> Please help support this email list: http://www.qsl.net/donate.html > > > > > > ______________________________________________________________ > > > Dxbase mailing list > > > Home: http://mailman.qth.net/mailman/listinfo/dxbase > > > Help: http://mailman.qth.net/mmfaq.htm > > > Post: mailto:Dxbase@mailman.qth.net > > > > > > This list hosted by: http://www.qsl.net > > > Please help support this email list: http://www.qsl.net/donate.html > > > > ______________________________________________________________ > > Dxbase mailing list > > Home: http://mailman.qth.net/mailman/listinfo/dxbase > > Help: http://mailman.qth.net/mmfaq.htm > > Post: mailto:Dxbase@mailman.qth.net > > > > This list hosted by: http://www.qsl.net > > Please help support this email list: http://www.qsl.net/donate.html > > ______________________________________________________________ > Dxbase mailing list > Home: http://mailman.qth.net/mailman/listinfo/dxbase > Help: http://mailman.qth.net/mmfaq.htm > Post: mailto:Dxbase@mailman.qth.net > > This list hosted by: http://www.qsl.net > Please help support this email list: http://www.qsl.net/donate.html ______________________________________________________________ Dxbase mailing list Home: http://mailman.qth.net/mailman/listinfo/dxbase Help: http://mailman.qth.net/mmfaq.htm Post: mailto:Dxbase@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html ______________________________________________________________ Dxbase mailing list Home: http://mailman.qth.net/mailman/listinfo/dxbase Help: http://mailman.qth.net/mmfaq.htm Post: mailto:Dxbase@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
