INFO: Visual FoxPro 5.0 Year 2000 Update

Article translations Article translations
Article ID: 239432 - View products that this article applies to.
This article was previously published under Q239432
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

SUMMARY

This article describes a patch for the LUPDATE() function in Visual FoxPro 5.0a. This patch updates the Visual FoxPro LUPDATE() function so it behaves the same as in Visual FoxPro 6.0.

MORE INFORMATION

In Visual FoxPro 5.0, the LUPDATE() function returns the date that a table was last updated. This date is read directly from the .dbf table header. However, because only two digits of the year are stored in the table header, the century in which the table was last updated is interpreted based on the setting of the SET CENTURY TO ROLLOVER.

With this update to Visual FoxPro 5.0, the LUPDATE() function behaves as it does in Visual FoxPro 6.0. In Visual FoxPro 6.0, LUPDATE() queries the Windows operating system to determine the date a table was last updated, allowing users to determine the century in which the table was updated. However, the table header continues to store the last two digits of the year it was last updated. This is done to ensure backward compatibility with other versions of FoxPro.

In order to apply the Visual FoxPro 5.0 year 2000 update, you need to have Visual FoxPro 5.0 Service Pack 3 installed. Download the LUPDATE() patch from:
http://download.microsoft.com/download/vfox50/Install/5.0/W9XNT4/EN-US/vfpy2k.exe
You can verify that the Visual FoxPro 5.0 2000 update is installed by right-clicking the Vfp.exe in Windows Explorer and selecting the Version tab. The file version should read "5.0a Build 415p."

Properties

Article ID: 239432 - Last Review: February 21, 2014 - Revision: 2.2
APPLIES TO
  • Microsoft Visual FoxPro 5.0a
Keywords: 
kbnosurvey kbarchive kbinfo kbxbase KB239432

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com