2 Replies Latest reply on Nov 1, 2012 2:56 PM by user485910

    How to Query for table that has trailing spaces in columns

      Hi to All,

      We have an AR Clerk who queries a customer invoice and receives the following error message: "FRM-40654: Record has been updated. Requery block to use change." And then the customer invoice appears.

      In reviewing ML found that there are some trailing spaces in columns. We have download the following script to locate the trailing spaces, afchrchk.sql.

      When we run the script its taking forever to complete. We would like to know if someone has modified the script to run on a certain record, as we know the record with that is causing this issue.

      Or has someone created their own script to locate the trailing spaces for a certain record in a table.

      Any help would be greatly appreciated.