I always use CLEARSELECT ALL before any EXECUTE "SELECT..." Without the CLEARSELECT ALL, strange things sometimes happen... like some other local user's program ran a SELECT and their SELECT results are still in memory.
--Bill -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Greer Sent: Friday, August 03, 2007 9:41 AM To: U2-Users (E-mail) Subject: [U2] EXECUTE environment in Universe Is there a configuration setting or $OPTIONS routine, other than $OPTIONS PIOPEN.EXECUTE, that keeps select lists active when an Execute command is run? Our software package uses basic programs with execute statements rather than procs to run reports. An example might be something like the following: EXECUTE 'SSELECT ORDER WITH B/O.FLAG "Y" BY CUSTOMER BY DUE.DATE' CAPTURING REPLY RETURNING MSG IF SYSTEM(11) = 1 THEN EXECUTE 'PRINT BACKORDER.REPORT' END I'm afraid of the unintended consequences of using PIOPEN.EXECUTE because EXECUTES are used throughout hundreds of programs and many include named common variables. _____ Dave Greer Director of Information Systems NewAge Industries AdvantaPure <http://www.newageindustries.com/images/nalogo.jpg> NewAge Industries, Inc. [EMAIL PROTECTED] www.newageindustries.com <http://www.newageindustries.com/> 215.526.2300 PHONE 215.526.2191 FAX <http://www.newageindustries.com/> Notice: If you are not the named recipient of this transmission, please notify us immediately, by telephone, and delete or destroy any copy of this message. You should not disclose or use this information in any way. Disclosure or use of this information may expose you to criminal or civil liabilities. We apologize for the inconvenience and thank you for your attention to this notice. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/