> >On the other hand: using select * for anything other than ad-hoc > >queries is bad. Should we support that? > > AFAIK, there's a long legacy, in Delphi components at least, of using SELECT * > as the dataset spec for emulating a "table" component (TTable and > derivatives). Sure, this goes back to half-cocked conversions from > antiquated desktop databases but I don't think it's a question of whether we > should (or not) support bad design and programming practices, if the SQL > standard actually permits them.
Agreed. In this case, the request is to add a new keyword/or some such that would "hide" fields from SELECT * ... (outside of the application of SELECT permissions) This is not supported by SQL Standard. Sean ------------------------------------------------------------------------------ Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel