I will look into how it works in version 10. At this stage, I am using the Jet engine used in Access 2007 so it will be interesting if it works the same (random) way! 73 Neal Campbell Abroham Neal Software www.abrohamnealsoftware.com (540) 645 5394 NEW PHONE NUMBER
Amateur Radio: K3NC Blog: http://www.abrohamnealsoftware.com/blog/ DXBase bug reports: email to ca...@dxbase.fogbugz.com Abroham Neal forums: http:/www.abrohamnealsoftware.com/community/ On Sat, Jul 31, 2010 at 10:44 PM, Tony <k...@comcast.net> 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
