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: wa6...@hotmail.com >> To: a...@mtaonline.net; dxbase@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: a...@mtaonline.net >>> To: dxbase@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"<a...@mtaonline.net> >>> To: "Crownhaven"<crownha...@bellsouth.net>;<dxbase@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"<crownha...@bellsouth.net> >>>> To:<dxbase@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-boun...@mailman.qth.net >>>>>> [mailto:dxbase-boun...@mailman.qth.net] >>>>>> On Behalf Of Gary AL9A >>>>>> Sent: Friday, July 30, 2010 2:14 AM >>>>>> To: Joe Duerbusch; DXbase@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"<jduerbu...@sbcglobal.net> >>>>>> To:<DXbase@mailman.qth.net> >>>>>> Cc: "Gary AL9A"<a...@mtaonline.net>;<k...@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@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@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@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@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@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@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@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@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
