>I don't think so. I've been using it in a bunch of similar views without a problem.
>
>>>
>>>If I put it in the DE of a form I get a "View definiton has been changed" error when it is requeried. If I remove the following from the view it works fine:
************
The only time I have seen this error is with calculated fields. The problem is that the first time you use the view, the field length (if it is a character) is set. If requery() and the value of that field is a different length then you get this error. The answer (for me) has been to absolutely fix the length of the field. Use PADR() PADL() LEFT(ALLTRIM(x)+SPACE(y),z) or some function like that to eleminate the posibility of the field being different when you requery and get a different record. You need to adjust this solution for your specific calculated field.
Dr. Ken A. McGinnis
Healthcare software design