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
