Field Validation Behaves Differently in dBASE IV & FoxPro

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

Last Reviewed: June 28, 1995