Enhancement: Views - Instead Of

[Cal Gordy]

The biggest problem we have with PLSD is it's handling of views.

Because of the treatment as simple Create or Replace DDL, Instead Of triggers are frequently lost as well as comments.

Can we look forward to more robust handling in the future?

Thanks

 

[Marco Kalter]

Yes. The upcoming 6.0 release will save and restore the instead of triggers when you compile a view.

 

[Cal Gordy]

Great - will be 'counting the minutes'

 

[John Owen]

I'm running 6.0.3.893 trial version and it is not saving and restoring the instead of triggers when you compile a view. Is this a feature only of the trial version ?

 

[Marco Kalter]

This is a feature of the SQL Window. Perhaps you are executing the "create or replace view" statement in another way?