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: [email protected] [mailto:[email protected]] On Behalf Of Gary AL9A Sent: Friday, July 30, 2010 2:14 AM To: Joe Duerbusch; [email protected] 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" <[email protected]> To: <[email protected]> Cc: "Gary AL9A" <[email protected]>; <[email protected]> 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:[email protected] 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:[email protected] This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
