Solved

Status not updated in a field and error not repeatable

Posted on 2001-07-12
1
197 Views
Last Modified: 2013-12-18
Now, i have to find a possible cause of error for the following piece of code:

@If(CMRStatus = "Business Input/Review Required" & CurrentStatus != CMRStatus; @Do(@MailSend(CreatedBy; ""; ""; "CR #" + CMRNo + " requires some additional Business Input/Review in the FS Destination database" ; "" ; "This change request for the " + Project +
 " project is either ready for your review or requires your additional input.  Follow this link for further details" +" ==>  "; [IncludeDoclink]);
@SetField("CurrentStatus"; CMRStatus); @PostedCommand([FileSave]));
CMRStatus = "Business Review Complete" & CurrentStatus != CMRStatus;
@Do(@MailSend("Rabinder X Kaur"; ""; ""; "CR #" + CMRNo + " has been updated by Business in the FS Destination database" ; "" ;
"This change request for the " + Project + " project has been updated by Business.  Follow this link for further details" +" ==>  "; [IncludeDoclink]);
@SetField("CurrentStatus"; CMRStatus); @PostedCommand([FileSave]));
CMRStatus = "Complete" & CurrentStatus != CMRStatus; @Do(@MailSend("Rabinder X Kaur"; ""; ""; "CR #" + CMRNo + " has been completed in the
FS Destination database" ; "" ; "This change request for the " + Project + " project has been completed.  Follow this link for further details" +" ==>  "; [IncludeDoclink]);
@SetField("CurrentStatus"; CMRStatus); @PostedCommand([FileSave]));"");
@PostedCommand([FileCloseWindow])


I tried recreating the error but i dont get it. therefore, it may have occured because-
1) if there are any replicas- the changes did not get replicated.
2) someone changed the status back to Build.
3) dont know!!!


Error as observed was:
I got this automated message that says this request has been completed, but when I go to the database, it is still listed in build with no comments.
0
Comment
Question by:puneetfred
1 Comment
 
LVL 18

Accepted Solution

by:
marilyng earned 100 total points
ID: 6447230
puneetfred;

Think the problem is the IF comparison.  You never really set the value of CMR status, and you need to declare the field before you use the @setfield statement.

Try this:
Field CurrentStatus :=CurrentStatus;
Status1="Business Input/Review Required";
Status2 ="Business Review Complete";
Status3="Complete";

@If(!@contains(CurrentStatus;Status1: Status2:Status3);
        @Do(
                     @MailSend(CreatedBy; ""; ""; "CR #" + CMRNo + " requires some additional Business Input/Review in the FS Destination database" ; "" ; "This change request for the " + Project +  " project is either ready for your review or requires your additional input.  Follow this link for further details" +" ==>  "; [IncludeDoclink]);
          @SetField("CurrentStatus"; Status1)          
                    );

      CurrentStatus= Status1;

    @Do(
               @MailSend("Rabinder X Kaur"; ""; ""; "CR #" + CMRNo + " has been updated by Business in the FS Destination
database" ; "" ; "This change request for the " + Project + " project has been updated by Business.  Follow this link
for further details" +" ==>  "; [IncludeDoclink]);    
            @SetField("CurrentStatus"; Status2)      
             );

             CurrentStatus = Status2;

             @Do(
                   @MailSend("Rabinder X Kaur"; ""; ""; "CR #" + CMRNo + " has been completed in the FS Destination database" ; "" ; "This change request for the " + Project + " project has been completed.  Follow this link for further details" +" ==>  "; [IncludeDoclink]);
                     @SetField("CurrentStatus"; Status3)              
                     );
"");

@PostedCommand([FileSave]);
@PostedCommand([FileCloseWindow])

See if it works for you,

Marilyng
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now