[Dxbase] Couple of items for next release

Sun Aug 1 20:34:10 EDT 2010

In the "For What It's Worth" department, I've gotten back three replies so 
far that the Compact database action does not correct the sort sequence 
problem in the Previous QSO's window. All three are using DXB2007. So from 
this extremely small, unscientific survey, I'm going to go out on a limb and 
surmise that there IS a difference in how DXB2006 and DXB2007 respond to the 
Compact database utility. Probably the only hope is that Neal's new version 
will address the situation when it is released.
73,
Gary AL9A
----- Original Message ----- 
From: "Gary AL9A" <al9a at mtaonline.net>
To: "Crownhaven" <crownhaven at bellsouth.net>; <dxbase at mailman.qth.net>
Sent: August 01, 2010 11:21 AM
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" <crownhaven at bellsouth.net>
> To: <dxbase at 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-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
>>>>>>>>>>> ______________________________________________________________
>> 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