[Dxbase] Previous QSO module DXb2006 versus 2007

Sun Aug 1 22:15:51 EDT 2010

Thanks Joe......
Steve, N4JQQ
On 8/1/2010 8:19 PM, Joe WA6AXE wrote:
> Gary and all:
>> Tryng to recall backwards by four years -- there is a difference
> between 2006 and 2007 -- the DXbase NOTES that came with
> 2007 state:
>> Modified the Previous QSO module so that partial lookups for callsign, special-1, and
> special-2 fields will be performed. For example, entering AA4 will return all records
> containing AA4. Entering AA4LU will return all records that contain AA4LU such as
> AA4LU/P...HA/AA4LU, AA4LU, etc...
>>> Apparently during this mod is where the changes we are seeing took place.
>>> 73 Joe wa6axe
>>>>>>> From: wa6axe at hotmail.com
>> To: al9a at mtaonline.net; dxbase at mailman.qth.net
>> Date: Sun, 1 Aug 2010 19:58:14 -0500
>> Subject: Re: [Dxbase] Couple of items for next release
>>>>>> Gary and all:
>>>> DXbase2006 Previous QSO window -- when you do a FIND of a PREFIX, the
>> listing is SORTED by Callsign (Ascending) and within Callsign - by date and time
>> (Ascending).
>>>> DXbase2006 Previous QSO window - when you do a FIND of a Specific
>> CALLSIGN, the listing is SORTED by DATE/Time (Ascending).
>>>> AND -- in DXbase2007 -- the FIND of a PREFIX - it is the SAME way as 2006 ..
>>>> BUT - when you FIND by CALLSIGN -- My listing is SORTED by DATE/TIME ** (Descending) ** .
>>>>>> Joe wa6axe
>>>>>>>>>>> From: al9a at mtaonline.net
>>> To: dxbase at mailman.qth.net
>>> Date: Sun, 1 Aug 2010 16:34:10 -0800
>>> Subject: Re: [Dxbase] Couple of items for next release
>>>>>> 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
>>>>>>> ______________________________________________________________
>>> 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
>>>