>>>>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 :(