I just compacted my database and then did a find in the "previous QSO" window using the find by QSO Field = CALLSIGN and ever one that I did a find on came up not sorted and in random order. So your last statement "when you FIND by CALLSIGN -- My listing is SORTED by DATE/TIME ** (Descending) **" Doesn't work that way for me. I am using DXBase 2007 73 de Tony, KD4K
-----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:58 PM To: a...@mtaonline.net; dxbase@mailman.qth.net 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
