|
Hi, I'm pretty new to using subprocedures & service programs, and this thread got me to thinking. Say I have a program where I would normally chain to the item master to get a description, item class, item type & cost. What would be the 'best' approach? 1) Chain to the item master & get all the fields 2) Use SQL to get the fields I need 3) Several subprocedures - GetItemDesc, GetItemClass, GetItemType & GetItemCost It just doesn't seem the multiple subprocedures can be very efficient when you are doing this for every line in a many page report. I am trying to use more subprocedures and service programs, because I see the value in reusable code. Many times however, I run into situations like the above, and it just seems quicker or easier to use the Chain or SQL. Any thoughts? <===================================================> Terri Harteau Felker Brothers Corporation **************** "The happiest people don't necessarily have the best of everything. They just make the best of everything!" ****************
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.