Hi,
Is there a way to set a field’s length to 20 characters when the data type for that field is long Integer?
I have inherited a database that is used daily to send files to an online application in the form of a text file with pipe delimiters. I was advised that one file is failing to load due to one of the fields within the file has a fixed length of 20 characters that has been changed.
I might have accidentally changed the set field length but do not know how I might have done this? I might have done this by changing the column (field) width?
The first failed notice that I received, stated that the set field length went from 20 characters to 41. Since the data type for this field was / is “long Integer”, and not seeing a way to change the length, I changed the width of the column.
The second failed notice then advised that the set length had changed from 41 to 29, so changing the width of the column I am assuming changed the set character length. Please correct me if my assumption is wrong?
So basically I have a file that is failing because one field’s set character length has changed and needs to be set back to a length of 20 characters.
How can I do this?
I would appreciate any input here.
Thank you.