I'm using 2007. 73 de Tony, KD4K -----Original Message----- From: dxbase-boun...@mailman.qth.net [mailto:dxbase-boun...@mailman.qth.net] On Behalf Of Gary AL9A Sent: Sunday, August 01, 2010 3:22 PM To: Crownhaven; dxbase@mailman.qth.net 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
