2 Replies Latest reply: Nov 1, 2012 9:56 AM by user485910 RSS

    How to Query for table that has trailing spaces in columns

    user485910
      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.

      Thansk