[Dxbase] Couple of items for next release
Tony
kd4k at comcast.net
Mon Aug 2 00:13:18 EDT 2010
I just compacted my database and then did a find in the "previous QSO"
window using the find by
QSO Field = CALLSIGN and ever one that I did a find on came up not sorted
and in random order.
So your last statement "when you FIND by CALLSIGN -- My listing is SORTED by
DATE/TIME ** (Descending) **"
Doesn't work that way for me.
I am using DXBase 2007
73 de Tony, KD4K
-----Original Message-----
From: dxbase-bounces at mailman.qth.net [mailto:dxbase-bounces at mailman.qth.net]
On Behalf Of Joe WA6AXE
Sent: Sunday, August 01, 2010 8:58 PM
To: al9a at mtaonline.net; dxbase at mailman.qth.net
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
More information about the Dxbase
mailing list