I'm confused. A view is nothing more than a saved query, really. A view isn't going to "store" unique data. (Well, you can use a view with triggers to update underlying tables, but I don't think that's what you're trying to do.)
If it were me, I'd be storing the non-calculated data in the database. I'm not quite sure what "extended price" is - but if it's simply the total (amount sold X price), then you shouldn't need to store that. You should store the amount sold and the price in the DB. You can write a view then that simply calculates that for you, so you don't have to write the query over and over, but it's really nothing more than writing the query once and running it with: create or replace myview AS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267258 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
