Before you can buffer a view you must create it, yes? And the view desiger trashes a view with more that *two* JOINED tables.
>Yes, that's SOP, but I'm unclear on how it relates to the discussion of buffering views. (I'm not trying to be argumentative...just afraid I've missed something in your point <s>.)
>
>
>About a zillion lines of code too quick :) Since the view designer totally screws up a view with more than two tables I've found it's a good way to get the basics built, then run GENDBC and pull out the code for the view. Then it's a piece-of-cake to clean up the JOINS of these *extremely* wordy CREATE VIEW commands and run the code to make it *right*.