> Absolutely...life is much easier when you can use a single cursor for the report's source. Makes it easier to issue a COPY TO out to a table so that you can check things when debugging too, imo.
-- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" I almost always do as you mention, creating a single cursor, and therefore no cursor name is necessary, but in this one case it was ultimately easier to do the report with three tables. This is after many, many attempts (with some success) using a final single cursor (I kept having issues with the data). Plus it was the one case where I felt I could make use of the new multiple detail band option in the report write. Question, could you use one cursor to run a multi-detail band report? Jim James E. Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com [EMAIL PROTECTED] 717-637-8931 fax: 717-637-6766 [excessive quoting removed by server] _______________________________________________ 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 ** 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.
