× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



On 3/16/2011 12:31 PM, Charles Wilt wrote:
On Wed, Mar 16, 2011 at 12:40 PM, James Lampert
<jamesl@xxxxxxxxxxxxxxxxx> wrote:
Charles Wilt wrote:
Also, if you plan for the users to sign on through JDBC with there own
user ID, you could make the tables PUBLIC *EXLCUDE and offer a view
that includes something to the effect of
create view myview
as SELECT col1, col2
from mytable
where SALE_REP = CURRENT_USER;
Fascinating. A view that checks some field against the current user.
Just out of morbid curiosity, is there a DDS Select/Omit equivalent to
the above WHERE clause?
Not that I'm aware of...views are lots more powerful than logical files.


Better for some things, perhaps. But there's no ORDER BY and as of recent releases they won't even work on legacy data with multiple formats. So, sure, views are great (I use them all the time) but they are not a silver bullet replacement for logical files.

Joe

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.