On Thu, May 24, 2012 at 10:24 AM, MB Software Solutions, LLC <[email protected]> wrote: > Using MySQL5, it looks as though I can't create parameterized views. > I've read the online docs and they say "The SELECT statement cannot > refer to system or user variables." Well, those user variables are what > we have as a parameterized view in VFP, right? > > So my plan B around this was to use VFP to cycle through the various > options and create the static views (hardcoded WHERE clauses to make up > for the lack of parm'd views). Result: 8480 views created within seconds. > > Gotta love VFP's ability to dynamically generate code in other languages > (in this case, MySQL) for you! > > I suppose I could create stored routines instead. Wondering about the > advantages of one over the other? ---------------
>From TSQL experience you can create the view and just put in a where clause with it. Depending on the view, usually, you will not receive the entire set of the table(s) and then filter it. MySQL I have no idea. The other option is to make some SPROCS and let them be in control. Now 8480 views sounds excessive! That many sprocs does as well. How many tables are in this system? -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell _______________________________________________ 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/cajidmylphvvrcwt9uawqu-pgtndz7mc99wubh+ubtqdijl_...@mail.gmail.com ** 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.
