Naomi's on the right track: that field will be set as either 7 chars or 8 chars depending on which option appears in the first row of the current query; but the DBC says it is -- well, whatever showed up when it tried to run it when making the DBC entry (it actually opens the view when doing this). Using CAST() will make it a definite length.

Hank

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