Interesting approach. Thanks. Continued Problem:
After correcting my "fetch" statement error, I continue to get the same results. I added a second hard coded "opunit" using a "where in" clause and moved the 2nd and 3rd email variables to a cc line and both emails ran with the appropriate copy. Taking the hard coding out and the email is only sent to the first variable address and the bcc address (static). Any additional thoughts? -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Tuesday, June 28, 2011 10:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Printing with Email Option Which is why I use a single fetch syntax. One less thing to forget...... WHILE (1) = (1) THEN -- Endless loop, use BREAK to exit Fetch ...... If SQLCODE = 100 THEN BREAK ENDIF -- code here ENDW Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, June 28, 2011 11:24 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Printing with Email Option At 12:07 PM 6/28/2011, Glenn Smith wrote: >If I hard code for "opunit", I get a single pass - and the report >is sent to all three addresses. If I run the cursor for all values >(take out the where clause), emails are only sent to the first >variable address. The second two are ignored. Any thoughts? Glenn, Looking closely at your code, the second FETCH variables do not match the first FETCH variables. Thus, the result is such behavior. Hope that provides you with some blue's clues ... Very Best R:egards, Razzak.
