You could try using eView. If you open your table with it, it automatically recognizes discrepancies between views and the underlying tables and offers to fix it for you. Automatically! Amazing...
you can get it here:
http://www.leafe.com/dls/vfp It is an old version, I don't know if there has been any updates.
>>>>>Hello
>>>>>I am getting a requery() errorwhen i click a buttonn fo run few of my views.
>>>>>it sayS:
>>>>>View definition has changed
>>>>>and it always points to a requery i cant comment out the requery cause ny tale is poopulated using that view an that used to be functional without giving me that error
>>>>
>>>>Post the view definition. See also
>>>>
View definition has changed MSDN thread>>>
>>>SELECT profile.appldate, profile.loanid, profile.flanumbr, profile.clientid,;
>>> profile.appnumber, identity.fbonumbr, identity.fbobname, identity.firstname,;
>>> identity.middlename, identity.lastname, profile.officerid, profile.officerid1,;
>>> profile.officerid2, profile.officerid3, profile.officerid4, profile.officerid5,;
>>> profile.date_pend, profile.date_rejec, profile.date_appr, profile.date_reg,;
>>> profile.date_lact, profile.loandesc,;
>>> IIF(profile.profiletatus=1,"New appl.",IIF(profile.profiletatus=2,"Pending",IIF(profile.profiletatus=3,"Rejected","Approved"))) AS applstatus,;
>>> profile.profiletatus;
>>> FROM ;
>>> mainbase!identity ;
>>> INNER JOIN mainbase!profile ;
>>> ON identity.clientid = profile.clientid;
>>> ORDER BY identity.fbobname
>>>
>>>
>>>
>>>then it has a whole list of stuff like
>>>
>>>DBSetProp(ThisView+".appldate","Field","DataType","D")
>>>DBSetProp(ThisView+".appldate","Field","UpdateName","mainbase!profile.appldate")
>>>DBSetProp(ThisView+".appldate","Field","KeyField",.F.)
>>>DBSetProp(ThisView+".appldate","Field","Updatable",.T.)
>>
>>In this view if you're using VFP change
>>IIF(profile.profiletatus=1,"New appl.",IIF(profile.profiletatus=2,"Pending",IIF(profile.profiletatus=3,"Rejected","Approved"))) AS applstatus,;
>>
>>to
>>
>>CAST(IIF(profile.profiletatus=1,"New appl.", ;
>>IIF(profile.profiletatus=2,"Pending",IIF(profile.profiletatus=3,"Rejected","Approved"))) as C(10)) AS applstatus,;
>>
>>We need to make sure that ApplStatus is a fixed length.'
>
>
>
>oh ok. Will try and tell you what happened just broke something else in the program :(