In my code below. no matter what I do the client value is changed. What I want to happen is - if the user select Yes then change. If the user select No exit
NewClient := @Prompt([OkCancelEdit];“Change Client Name” ; “Enter your client name.” ; “”);
lookup := @DbLookup(“”:“NoCache”;“”; “vClientList”;Client;1);
@If(NewClient = lookup; @Return(@Prompt([Ok]; “Duplicate Client”; “Client Name must be unique!”)); “”);
FIELD Client := NewClient;
result := @If(NewClient != lookup;@Return(@Prompt([YesNo];“Client Name Change”;“If you continue the master document and all Document Review Requests for " + lookup + " will be changed to " + Client ));”");
@If(result = 1;@Return(“”);“”)
Subject: You have a bunch of problems…
NewClient := @Prompt([OkCancelEdit];“Change Client Name” ; “Enter the new name for '” + Client + “'.” ; “”);
lookup := @DbLookup(“”:“NoCache”;“”; “vClientList”; NewClient; 1);
@If(NewClient = lookup; @Return(@Prompt([Ok]; “Duplicate Client”; “Client Name must be unique!”)); “”);
result := @Prompt([YesNo];“Client Name Change”;"If you continue the master document and all Document Review Requests for " + Client + " will be changed to " + NewClient )
@If(result = 1; “”; @Return(“”);
FIELD Client := NewClient;
Subject: @prompt and @Return
NewClient := @Prompt([OkCancelEdit];“Change Client Name” ; “Enter your client name.” ; “”);lookup := @DbLookup(“”:“NoCache”;“”; “vClientList”;Client;1);
@If(NewClient = lookup; @Return(@Prompt([Ok]; “Duplicate Client”; “Client Name must be unique!”)); “”);
result := @Prompt([YesNo];“Client Name Change”;"If you continue the master document and all Document Review Requests for " + lookup + " will be changed to " + Client );
@If(result = 1;@Return(“”);“”);
FIELD Client := NewClient