From: Mike Dee on 7 Mar 2010 00:02 In article <52ead6f3-b85a-47c3-85c8-bc6b5d7ffeeb(a)e1g2000yqh.googlegroups.com>, wylbur37 <wylbur37nospam(a)yahoo.com> wrote: > On Mar 1, 4:22 pm, "B. R. 'BeAr' Ederson" > <br.eder...(a)expires-2010-03-31.arcornews.de> wrote: > > On Mon, 1 Mar 2010 08:14:08 -0800 (PST), wylbur37 wrote: > > > A friend of mine who has been using a DOS version of dBase for years > > > and years is now interested in switching to something newer and > > > more recent, especially since his dBase isn't Y2K compliant. > > > > Which version? [...] > I don't recall which exact version he has. > He had been using a two-digit year code, so any dates whose year > is 2000 or later end up sorting as "earlier" than dates > of 1999 or before, and he's not sophisticated enough > to write scripts. > Also, he needs to be able to do joins > (as in the case of a mailing list where someone > has multiple addresses). Perhaps one of these listed here will do: <http://www.pricelesswarehome.org/acf/P_BUSINESS-HOME.php#2.20Database> I don't know too much about database programs but the above link lists several. My limited database requirements are served using OpenOffice (its "Base" component) which does support dBase files, see: <http://www.openoffice.org/product/base.html> -- dee
From: B. R. 'BeAr' Ederson on 7 Mar 2010 03:40
On Sat, 6 Mar 2010 12:32:49 -0800 (PST), wylbur37 wrote: [dBase and Y2K] > I don't recall which exact version he has. > He had been using a two-digit year code, so any dates whose year > is 2000 or later end up sorting as "earlier" than dates > of 1999 or before Date fields have been introduced with dBase III (released 1985) and *always* stored years with 4 digits. So your friend either used an even earlier version or ignored the date fields in newer versions. Either way, the two digit date fields will be hand-crafted by himself... ;-) > and he's not sophisticated enough to write scripts. Also, he needs to be > able to do joins (as in the case of a mailing list where someone has > multiple addresses). I'd still say, he should give Diabolic Preachers suggestion of using OpenOffice Base a try. BeAr -- =========================================================================== = What do you mean with: "Perfection is always an illusion"? = ===============================================================--(Oops!)=== |