>Is there any other way to modify the local view in Windows command instead of using the modi data to modify?
You can use the Create SQL View syntax to recreate the view and then use DBSetProp() to set any field or view properties you may need. For more information, see these topics in the VFP help.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao