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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement