Skip to main content

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

Hi @bucrobsired,

This is too specific an issue for the forums to answer. You will need to engage with IFS or a partner directly to work through this issue and the requirements to find a solution.

Kind regards,

Lee Pinchbeck

Hey @bucrobsired 

I had a similar issue.

Try using char(10) (New Line / Line Break) instead of char(13) (Carriage Return) in your SQL script.

It gives a similar result but without the DB error.

Cheers!

thank you so much for your assistance. That worked a treat!

Reply


Terms & ConditionsCookie settings