VFP GETFLDSTATE function| check field modify or not in vfp | table field...

IF GETFLDSTATE("CITY") = 1

MESSAGEBOX("City Not Modified",0+64,"Manoj Kalla +919869166077")

ENDIF 

IF GETFLDSTATE("CITY") = 2

MESSAGEBOX("Yes, City Modified",0+64,"Manoj Kalla +919869166077")

=TABLEUPDATE(.T.)

ENDIF 

vfp Getenv function | get windows folder path in vfp | system user name ...

?GETENV("APPDATA")    : Application's User setting and configuration data.

?GETENV("COMPUTERNAME") : Computer Name

?GETENV("USERDOMAIN")

?GETENV("LOGONSERVER") : Server Name / Computer name

?GETENV("USERDOMAIN_ROAMINGPROFILE")

?GETENV("CommonProgramFiles") : ProgramFilesx86

?GETENV("CommonProgramFiles(x86)") : ProgramFilesx86

?GETENV("CommonProgramW6432") : CommonFiles 

?GETENV("ComSpec") : CMD.exe path

?GETENV("HOMEDRIVE") : Return Base drive / Windows Installation Drive

?GETENV("SystemDrive") : Return main system drive / windows drive

?GETENV("HOMEPATH") : Return \User\Admin path

?GETENV("LOCALAPPDATA") : Return Local AppData Path= C:\Users\Admin\AppData\Local

?GETENV("OneDrive") : Return OneDrive path.

?GETENV("OneDriveConsumer") : Return OneDrive path.