Re: Another intriguing one...

Dear Billy, It depends on the select statement that is used to create the view. If you are using correlated subqueries then you will get log entries. In some versions temp tables get logged in select statements also. It has nothing to do with being a view as such. If they execute the same select statements that create the view instead of using the view then they will also see these being logged. HTH Regards, Jason On 10 Sep 1997 09:48:22 -0400, billy@west.co.za ("Billy Wheeler") wrote: >G'day all. > >I'm giving a training course at the moment to a bunch of long-time >OnLine 5 users, and boy, am I getting asked some interesting >questions! :-) > >Here's one: under 5.x on Solaris and SunOS, they claim to get SELECTs >from VIEWs recorded in the logical logs, whereas SELECTs from base >tables (quite rightly) do not appear in the logical logs. Are they >smoking their proverbial socks, or is there some justification for >this bizarre claim? > >All comments gratefully received... > >-- >Ciao, >Billy > >Nose to the ear in Dubai, home of sun, fun and 100% humidity... >For a good time, call: http://www.iiug.org/techinfo/faq/faq_top.html