>>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.)