From: Mike Dee on
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
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!)===