On Tue, Jan 14, 2014 at 1:39 PM, < [email protected]> wrote:
> On 2014-01-14 14:37, Stephen Russell wrote: > >> So you have to rewrite this similar code block for every time you have >> this >> need? That would never make it in one of our builds. As you save your >> code it would cough up that hairball. >> > > > No, there's no rewrite. It's a fixed set of function calls where the > driving loops outside are one for Regions and within each region, another > loop for the LineNo (which via JOINS to a mapping table derive the > specifics of the query). It's reusable and quite slick, actually. > ---------------- > I was thinking along the lines of how many sprocs get you a single 1 row and 1 column answer? If many than you may need to reconsider. I am not considering only 2 input params for the sproc but N in count could be run. VFP doesn't care about what is in a var when you stuff it so this seems a little easier. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyjfzw1tln1ptsh3v89cmtqnfyg_rxypbgb2r4gtsdj...@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.
