John:
>>Actually you can create a new RV completely in *code*.
Thats what I meant when I said rebuild it. If you want to change the SQL prop, you've got to close the tables in the DE, drop View from DBC, rebuild it then add it back. That a lot of overhead. OTOH, an SPT cursor can be required and the new cursor just overwrites the old.
>>I see no huge difference between code to recreate a RV and code to recreate a >>SP.
There is never a need to change a SP during runtime.
This thread is getting old, let talk about something else :)
Regards
Charlie
Précédent
Suivant
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