Mark Stanton wrote: > In article <[EMAIL PROTECTED]>, MB Software Solutions > wrote: > >> The data in the grid is a parameterized view, using several "filter" >> variables from the choices above the grid. >> >> Here's the WHERE clause of my view that enables the "filtering" : >> > > Yup, that's the kind of thing. (Where's that view editor come from? I > remember seeing it before but have lost track of it now.) >
ViewEditor is a great tool offered by Rick Schummer: http://www.whitelightcomputing.com/prodvieweditorpro.htm It makes working with views a lot easier (as usually is the case with Rick's tools). > I think my concern comes from the level I'd have to do this at. > I'd be practically making public variables to hold the thing together, > because > the user will want to set up some filters (this year, those traders, these > markets), and then a large number of views will need to have those types of > parameterised clauses. > You don't have to use (nor would I recommend) public variables...you can use PRIVATE scoped variables. -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
