>>I have a p-view defined that works in most cases. However, occasionally, and always in the same spots as I page up and down the parent, I get error #1494: View definition has changed. Obviously, the definition hasn't changed--something else is going on. But I cannot see what it is--the data all looks good. Any ideas out there where to begin to look to sleuth out this problem?
>>
>>TIA.
>>John
>
>There are several suspect things in a view definition that can cause this. Can you post the SQL that creates your view?

Eric & Nancy:

Thanks for jumping in here--I still can't figure this thing out. Here is the SQL:

SELECT Schedule.term, Schedule.discipline, Schedule.level,;
Schedule.section, Student.name, IIF(Enroll.drop,"Dropped",""),;
Schedule.pkey, Enroll.pkey, Student.pkey, Student.block,;
Student.preregterm;
FROM ieli!schedule INNER JOIN ieli!enroll;
INNER JOIN ieli!student ;
ON Enroll.stufkey = Student.pkey ;
ON Schedule.pkey = Enroll.schedfkey;
WHERE Schedule.term = ?vTerm;
AND Schedule.level = ?vLevel;
AND Schedule.section = ?vSection;
AND Schedule.discipline = ?vDiscipline;
ORDER BY Student.name

I am using VFP 6.0 and have the view in the DE of a form. This is an app for a school. I have a Schedule grid on the left tied to the Schedule table and a grid on the right tied to this view. Every time I change records in the Schedule grid, I REQUERY the view and show in the right hand grid all the students enrolled in the class. Works great for most records. However, there are a consistent few Schedule records that trigger the View Definition Has Changed error. There has to be something in the data, but I can't for the life of me see what it is, and the error message is of no discernible value. Any ideas??

TIA,
John