Hi Dave.

>In VFP 7 ....
>
> When I build a view 'x' based on table 'y' and then modify the structure of table 'y' does view 'x' break?

This hasn't changed in VFP 7, and I doubt it ever will. It's just a artifact of how views are stored in the DBC.

> With VFP 5,6 I found using the referential integrity builder slowly down massive APPEND operations on table when importing new data.

That makes sense, since for every record inserted, a trigger fires, VFP has to find the code in the stored procedures, and execute that code. You might want to do the following when you have a massive APPEND to do:

- Use AFIELDS() to get the current triggers for a given table.

- Use DELETE TRIGGER to remove the triggers without touching the code called by those triggers.

- Perform the APPEND.

- Use CREATE TRIGGER to put the trigger expressions back.

Doug