We have recently upgraded to FSM6 from Metrix5. in Metrix we added lines to the request description field (request.cust_prob_descr) using SQL Agent jobs, and started each added line with a CHAR(13) carriage return. in FSM we are unable to make changes to any other request field via the User Interface (desktop client) on any request where one of these lines with a carriage return has been added. On Save we get an FSM Error message on a pop-up with the statement:
“Row(request_request, ([request_id])) was changed after it was selected. Reselect and try again.”
If we remove the carriage return on Excel and reimport the description, or if we remove the carriage return with a sql update then we are able to modify the request again using the User Interface. Unfortunately we require the added information lines and the carriage returns in the description for our mobile application. Therefore we want to be able to make changes to any request field AND keep our char(13) in the description field.
Any help or ideas gratefully received
Best answer by Shneor Cheshin
View original
