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.
--- RBASE-L
=======================3D=======================
D=
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
=======================3D=======================
D=
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
=======================3D=======================
D=
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
=======================3D=======================
D=
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
=======================3D=======================
D=
