Microsoft KB Archive/249900: Difference between revisions
m (Text replacement - "<" to "<") |
m (Text replacement - """ to """) |
||
Line 79: | Line 79: | ||
<li><p>Copy the following code and save it in a .prg file:</p> | <li><p>Copy the following code and save it in a .prg file:</p> | ||
<pre class="codesample">CLOSE ALL | <pre class="codesample">CLOSE ALL | ||
fname=GETFILE( | fname=GETFILE("dbf") | ||
IF EMPTY(fname) | IF EMPTY(fname) | ||
RETU | RETU | ||
Line 100: | Line 100: | ||
This method only works for Visual FoxPro 5.0 and 6.0. | This method only works for Visual FoxPro 5.0 and 6.0. | ||
<ol> | <ol> | ||
<li><p>Run the Hexedit.scx form from the SYS(2004)+ | <li><p>Run the Hexedit.scx form from the SYS(2004)+"\Tools\Hexedit" folder by using the following command:</p> | ||
<pre class="codesample">DO FORM SYS(2004)+ | <pre class="codesample">DO FORM SYS(2004)+"\tools\hexedit\hexedit" | ||
</pre></li> | </pre></li> | ||
<li>Select the .dbf file to be updated.</li> | <li>Select the .dbf file to be updated.</li> |
Latest revision as of 13:51, 21 July 2020
Article ID: 249900
Article Last Modified on 5/12/2003
APPLIES TO
- Microsoft Visual FoxPro 3.0 Standard Edition
- Microsoft Visual FoxPro 3.0b Standard Edition
- Microsoft Visual FoxPro 5.0 Standard Edition
- Microsoft Visual FoxPro 5.0a
- Microsoft Visual FoxPro 6.0 Professional Edition
- Microsoft FoxPro 2.5b
- Microsoft FoxPro 2.5a
- Microsoft FoxPro 2.5b
- Microsoft FoxPro 2.6 Standard Edition
- Microsoft FoxPro 2.6a Standard Edition
This article was previously published under Q249900
SYMPTOMS
An error message may appear in some applications when you open or import a FoxPro table that was created or modified after 12/31/1999.
CAUSE
The error message may be caused by one of the following:
- The second byte of the FoxPro table header is a hex value and is reset to 00 in the year 2000 and increments by 1 each year (that is, 01 in 2001) by FoxPro. Some applications treat this value as an offset from 1900 and continue to increment the hex value (63, 64, 65 ... representing 1999, 2000, 2001 ...). The original file format definition allowed some ambiguity, so either interpretation is common.
- If the application is reading the second byte of the FoxPro table header, which represents the year of table creation or modification, then the hexadecimal 00 may be interpreted as character NULL rather than a date.
- The application may add the value of the second byte of the FoxPro table to the year 1900.
RESOLUTION
The FoxPro table header stores the information for the date of creation or modification of the table. The code in Method 1 changes the second byte of the header to the CHR() value of the year of the system date minus 1900. Please note that the changes to the table header shown in Method 1 and Method 2 are temporary. The next time FoxPro modifies the table header, for example when it appends a blank record, the byte reverts back to its original value.
To resolve this problem, use one of the following methods: METHOD 1
This method works for FoxPro versions 2.x and all versions of Visual FoxPro.
Copy the following code and save it in a .prg file:
CLOSE ALL fname=GETFILE("dbf") IF EMPTY(fname) RETU ELSE fh = FOPEN(fname,12) ENDIF IF fh < 0 WAIT 'Cannot open or create output file' WINDOW NOWAIT ELSE =FSEEK(fh, 1, 0) =FWRITE(fh, CHR( YEAR( DATE() ) - 1900)) =FCLOSE(fh) WAIT 'File Updated Successfully' WINDOW NOWAIT ENDIF
- Run the .prg file and choose a .dbf file to be updated.
METHOD 2
This method only works for Visual FoxPro 5.0 and 6.0.
Run the Hexedit.scx form from the SYS(2004)+"\Tools\Hexedit" folder by using the following command:
DO FORM SYS(2004)+"\tools\hexedit\hexedit"
- Select the .dbf file to be updated.
- Click the value of column 1 for address 00000000.
- Change the value from 00 to CHR(YEAR(DATE()) - 1900). For example, use 64 for 2000, and 65 for 2001.
- Click Close.
- Click Yes to save the sector on the disk.
METHOD 3
Use the Visual FoxPro ODBC driver to connect to the table.
STATUS
This behavior is by design.
MORE INFORMATION
Additional query words: Y2K
Keywords: kbcodesnippet kbdatabase kbprb kb3rdparty KB249900