Vendor Field needs to be expanded to allow more characters

I updated the IDO Property to 2500 characters from 1000 characters. Now when I try to save a record with more than 1000 characters I receive the error the String or BInary can not be truncated. Where else do I need to change the property to allow for more characters?

Find more posts tagged with

Accepted answers

All comments

Legacy Contributor

You also need to increase the size of the table field in the SQL Tables form. They both need to reflect this change.

0904080939293831.xls

mtolliver

Is there a trick to being able to edit them? I don't see the access as on this form to allow me to change the read only fields.

Rene Bottern

Change the "Data Type" to something you can control (i.e. 'nvarchar')

Rees Howel

While changing the data type of a standard Infor field is feasible, it's generally a bad idea in the long run because you have no control over when Infor release a patch which will undo your changes. Also, it isn't always easy to gauge the impact these sort of changes have on other things (particularly Utilities and Reports). It's probably fairly limited in this specific example but not always.

It is generally much safer to add a UET of appropriate length field and change the binding on the form edit box and gridcol to the UET.

mtolliver

Thank you - I had thought about that but didn't want to have mod all the places this field shows up on reports etc. I did validate that there is very minimal use across the database of this particular field so thought it was worth a shot just changing the length. In the end I may go the UET route as we will be needing to modifying the printed reports as well anyway. Thanks for the input.

mtolliver

Thank you this worked

Copyright © 2025 Infor. All rights reserved.