>Of course if you're asking about FoxPro 1.02 (was there a 1.01?)

Finally I've seen 1.01 mentioned somewhere. I thought I've invented some history - nobody else seemed to remember it. We've had it in some form of evaluation until we received the legal copy, which turned out to be the 1.02. This.memory.refresh()...

> you must be talking about a legacy app *written in* FoxPro 1.02, surely you wouldn't be using it for new development ... and there's no guarantee that the programmer who wrote the old app didn't do lots of non-Y2K-compliant things when writing the code. For instance, did they make indices based on 12/31/99-DateField to sort in reverse-date order (I've seen it done).

And it should continue to work fine with such an index, as long as they didn't apply STR() to the expression. If it remained numeric, it's still OK.

>There are a lot of potential problems to look for when examining an old application for Y2K compliance. There are several tools written for doing this specifically in FoxPro (my company has written one). Just because the tool itself can be called mostly Y2K compliant, doesn't guard you against a bonehead who may have been using the tool ten years ago.

Right. I've caught myself swatting my right hand with my left every time I invented something based on dates, that could break before I retire :)

BTW, look at this one:

Translated from Latin scroll dated 2BC

Dear Cassius:

Are you still working on the Y zero K problem ? This change from BC to AD
is giving us a lot of headaches and we haven't much time left. I don't know
how people will cope with working the wrong way around. Having been working
happily downwards forever, now we have to start thinking upwards.
You would think that someone would have thought of it earlier and not left
it to us to sort it all out at this last minute.

I spoke to Caesar the other evening. He was livid that Julius hadn't done
something about it when he was sorting out the calendar. He said he could
see why Brutus turned nasty. We called in Consultus, but he simply said
that continuing downwards using minus BC won't work and as usual charged a
fortune for doing nothing useful. Surely we will not have to throw out all
our hardware and start again?

Macrohard will make yet another fortune out of this I suppose. The money
lenders are paranoid of course! They have been told that all interestrates
will invert and they will have to pay their clients to take out loans.

It's an ill wind ......

As for myself, I just can't see the sand in an hourglass flowing upwards.
We have heard that there are three wise men in the East who have been
working on the problem, but unfortunately they won't arrive until it's all
over.

I have heard that there are plans to stable all horses at midnight at the
turn of the year as there are fears that they will stop and try to run
backwards, causing immense damage to chariots and possible loss of life.

Some say the world will cease to exist at the moment of transition. Anyway,
we are still continuing to work on this blasted Y zero K problem.

I will send a parchment to you if anything further develops.

If you have any ideas please let me know,

Plutonius