Re: Code Re-Use Via Views

Windcliff, the basic idea is sound, but you have to carefully look at each query and determine which ones the technique will add value to and which ones need to be handled differently.

Stored procuedures that return a cursor may be another option that you can use.

And sometimes nearly, but not quite, identical code will need to appear in the programs.

• Mark D Powell --