[Dxbase] Couple of items for next release

Sun Aug 1 16:00:42 EDT 2010

I'm running 2007.
Steve, N4JQQ
On 8/1/2010 2:21 PM, Gary AL9A wrote:
> 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 
>>