>> About queries, suppose i need to query an invoice, one query needs all the suppliers, the other one just dates, both use the invoice header table. Should i create two different queries or just one that brings in all the columns in a cursor, which r then selected for each query ?<<
If you have one query you likely have one data object. This data object can communicate with one or more business objects. You can load up the business object with many custom methods for the business scenario. Or you can go granular if that makes more sense. I am not sure there is a right or wrong approach depending on your application needs. Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com _______________________________________________ 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/00bf01cb900c$926aa120$b73fe3...@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.
