TIP: Click on subject to list as thread! ANSI
echo: foxpro
to: GILLES BEAUREGARD
from: CY WELCH
date: 1996-12-31 17:43:00
subject: YEAR 2000

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)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.