[Dxbase] Couple of items for next release

Sat Jul 31 23:34:09 EDT 2010

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-bounces at mailman.qth.net [mailto:dxbase-bounces at mailman.qth.net]
> On Behalf Of Gary AL9A
> Sent: Friday, July 30, 2010 2:14 AM
> To: Joe Duerbusch; DXbase at 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"<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
>>>>>>>>>> ______________________________________________________________
> Dxbase mailing list
> Home: http://mailman.qth.net/mailman/listinfo/dxbase
> Help: http://mailman.qth.net/mmfaq.htm
> Post: mailto:Dxbase at 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 at mailman.qth.net
>> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html
>>>