Hello Gilles!
Saturday December 21 1996 07:09, Gilles Beauregard wrote to Randall Bosma:
RB>> GB\ Just to ask if you are YEAR 2000 ready. I know FP
RB>> was 2000 ready, but
RB>> \ the application you develop are?
RB>> Yes, thankfully FoxPro is ready for the next millenium. In the
GB> It's what I assume until yesterday. I do some Y2K check on a flat
GB> file. Only the basic file with some date field and some index
GB> in that date field.
GB> I check what append when you enter 00/12/12 as the date. And
GB> FoxPro assume it's 1900/12/12, not 2000/12/12. And the result was
GB> a mix up of the index file, so I have to correct it. Lucky it's only
GB> a 500 records file, I don't lost anything.
If you don't SET CENTURY ON then its not foxpro that is not ready, but rather
YOU that have written a program that is not ready. Use of 2 characters for
the year is BAD programming anymore (and really has been for several years
now). For that matter how could foxpro assume anything OTHER than the current
century if you don't supply it. However you are right in that even if you
set the date to 2000 or later it will still assume 1900 if you put in 00.
However, I am sure that vfp 6.0 (due out before the turn of the century) will
fix that. (heck maybe 5.0 did, I will check when I get a chance).
GB> In conclusion I have to re-write ALL application already done.
You would anyways. How can you make an assumption about the century of ANY
date this close the 2000? That is VERY bad programming practice.
GB> If FoxPro was really a true Y2K ready package, it's assume
GB> 2000 when you write 00 in a 2 digits date field.
No, that would make it unsuitable for MANY types of applications. Basically
anything written now should either use the current century for the
assumption, or REQUIRE that you enter the century. In any case you MUST have
4 digit years, to allow for date entry on BOTH sides of the century mark.
GB> I do the check in 2.6x DOS of FoxPro. Anyone can check if the
GB> same Y2K bug with the lastest version?
As far as I know, it exists on all platforms. But being 2k ready has nothing
to do with making assumptions, but rather with storing the data in such a way
as to allow things to work. Simply setting CENTURY on will make foxpro
applications 2k ready.
Cy
Internet: Cy.Welch@pmra.gigo.com
cwelch@calweb.com
Web Page: http:/www.calweb.com/~cwelch/
FTP DIR: ftp:/ftp.calweb.com /users/c/cwelch/
... Operator, give me the number for 911.
--- GoldED/386 2.50+
---------------
* Origin: PMRA Tech Support 916-448-5376 (FIDONET 1:203/123)
|