Can anyone offer an explanation for this scenario.

 

A script on the client creates a new record in table A.  Within that same script, Perform script on server is called with two parameters.  Parameter 1 is the serialized id of the record just created ( the id is created upon record commit.), and parameter 2 is a global field from a different table.  The Psos script goes to a layout for table B.  Parameter 2 is used to find the correct record.  A field in the found record is then set to parameter 1.

 

The problem is the field set to parameter 1, has the value of parameter 1 and a carriage return.

 

I don't know where the carriage return is coming from.  Parameter 2 is fine with no carriage return.

 

I have tried List( param1; param2) and switching to List(param2; param1) and it produces the same results.  I am parsing using "MiddleValues( Get( ScriptParameter); 1; 1)" 

and "MiddleValues( Get( ScriptParameter); 1; 2)

 

Since the Id field is not editable by any user, I know it is not an input error by a user.

 

What is going on?

 

 

http://fmhelp.filemaker.com/fmphelp_13/en/html/func_ref3.33.74.html#1048685

 

states that “each value that is returned ends with a carriage return, allowing lists to be easily concatenated.”

 

Since you only need a single value anyway, use GetValue ( Get( ScriptParameter); 1 ) and GetValue ( Get( ScriptParameter); 2 )

Thanks so much