Microsoft KB Archive/115954

{| = Field Validation Behaves Differently in dBASE IV & FoxPro =
 * width="100%"|

ID: Q115954

The information in this article applies to:


 * Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b, 2.6
 * Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, 2.5a, 2.5b, 2.6
 * Microsoft FoxPro for Macintosh, versions 2.5b, 2.5c

SUMMARY
In dBASE IV, field validation will not occur unless a change is made in the field. However, in FoxPro, field validation is forced even though no change is made to the field. Issuing SET COMPATIBLE DB4 does not make FoxPro behave like dBASE IV.

MORE INFORMATION
To demonstrate this behavior, run the following code in FoxPro:

SET COMPATIBLE DB4

@ 10,10 GET memvar1 DEFAULT SPACE(10) VALID mytest @ 11,10 GET memvar2 DEFAULT SPACE(10) VALID mytest READ

FUNCTION mytest WAIT WINDOW "In VALIDation function..." RETURN .T. NOTE: Press ENTER in the GET fields. Additional reference words: FoxMac FoxDos FoxWin 2.00 2.50a 2.50b 2.60 2.50c KBCategory: kbprg KBSubcategory: FxinteropDbase
 * }