Select vs Choose

[Ohmes, Matt]

I guess it would depend on the frequency of reports based on that view.
That is certainly a viable option, but generally, I find programmers are not
necessarily allowed to create views in the database. 
If the same tables are being joined for several reports, sure, make the
view. :-)
 
Matt

Matt.Ohmes@Cognos.Com
Cognos Corporation
909 E. Las Colinas Blvd.
Suite 1900
Irving, TX  75039
214-259-6200
"Matt doesn't really know anything.  He just likes to pontificate a lot.
We refuse to acknowledge that he works for Cognos or that we have ever
met him or anyone with whom he's ever been associated.  Don't lend him
money and don't let him talk to your sister!" ;-)


-----Original Message-----
From: Brent Gillan [mailto:bgillan@aerocomp.ca]
Sent: Wednesday, September 01, 1999 2:07 PM
To: Powerhouse List
Subject: Re: Select vs Choose


Instead of creating cursors in the source code, wouldn't it be more
feasible to create a database view ?
If multiple programs had cursors coded in them, and a change was
required, wouldn't the maintenance be easier if all you had to do was
change 1 view ?
---
Brent Gillan
Aerocomp Solutions Inc.
mailto:bgillan@aerocomp.ca


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.