[Dxbase] Couple of items for next release

Fri Jul 30 02:13:56 EDT 2010

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" <jduerbusch at sbcglobal.net>
To: <DXbase at mailman.qth.net>
Cc: "Gary AL9A" <al9a at mtaonline.net>; <k0bx at 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
>>>>