I am running DXB 2007 and compacting the database does not work for me. Bill W5VX
-----Original Message----- From: dxbase-boun...@mailman.qth.net [mailto:dxbase-boun...@mailman.qth.net] On Behalf Of Crownhaven Sent: Sunday, August 01, 2010 3:01 PM To: Gary AL9A Cc: dxbase@mailman.qth.net Subject: Re: [Dxbase] Couple of items for next release I'm running 2007. Steve, N4JQQ On 8/1/2010 2:21 PM, Gary AL9A wrote: > 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
