What I am trying to do is simply take the content that I typed in one of the element of the form and put that into one of the element of the other open form. For that I am using "Copy" command button. I have tried to use SetCopyBuffer ( ) and @GetSelectionContents() on form Reveal event, also tried to use FormRunProgram ( ). Both of them work but both of them - eventhough I have closed the first form, it takes me back to the form again one more time.  So I thought of using FormRunCustomProgram ( ).  As you can see from my note, I am unable to make it work using any variable for value and it will be difficult to use concrete value in the program. I will appreciate if someone find a way to have the command works with a variable.

Following is the code in Copy Command Button. Code is the element, the content of which I am trying to copy and place it in the other open form.

var vCode as string
var vSecondPart as String


//SetCopyBuffer (Code)

//WriteLn(@GetSelectionContents()  )

//ClientLocalValue ("CopyImm", "Copied")
//ClientLocalValue ("SubjectRecNumber", RecNumber)

//ClientLocalValue ("RecommendedImm", Code )

vCode = Code


vSecondPart = "ImmR = 1000"   // works

//vSecondPart = "ImmR = " + vCode  //does not work



//vSecondPart = @Chr (34) + "ImmR = " + vCode + @chr (34)    //does not work

WriteLN (vSecondPart)

//FormRunCustomProgram("Physical", "ImmR = " + vCode )   //Does not work

//FormRunProgram ("Physical", "Imm_Record", PROGRAM_EVENT_LE_CHANGE )

FormRunCustomProgram("Physical", vSecondPart )

Clear (Code)

@Exit

 

Thanks for response.  Other form is open and not saved yet. It is in @add mode. Do not know for sure if other records are there in @add mode of that particular form that are already saved.  Just wondering if that would work? Also noted that FormRunCustomProgram ( ) would not work if the value in the program is not just numbers.

Hello Bharat,

1: It does work with a variable and with a text value but you have to be sure to write it correctly. Let's take the following code

vCode = "TestCode"
vSecondPart = "ImmR = " + vCode  

When executed vSecondPart is going to equal
Quote:


If you were to copy that into the programming editor of your Physical form and test it, it would throw an error saying it doesn't know what TestCode is. The same is gonna hold true for FormRunCustomProgram() it can't compile as it doesn't know what TestCode is. However,

Quote:

Will compile, so that is what we need to generate. That means our code needs to be

vCode = "TestCode"
vSecondPart = "ImmR = """ + vCode + """" 

The reason it is working with numbers is because Sesame knows what 1000 is.

as for #2 and #3, I would have to see the behavoir in person to determine why it is doing what it is doing. Once you start mixing On Form Reveal with commands that Open or Close other forms, or even switching to other forms there gets to be a lot going on.

-Ray

Got it now! The following is a little simplified for my understanding and it worked fine so did the FormfieldValue ( ). Thanks.

vSecondPart = "ImmR = " + @Chr (34) + vCode + @Chr (34)