something weird is going on! the last field in each of my records contains zzzzz that is 5 z's. if i modify a record it adds a space making the field 5 characters but still 5 z's. because that field size is limited to 5 characters, i get an error message saying the field has 6 characters. if i re-submit the form with no changes, it gives an error message saying the field has 7 characters!
i listed all the records and included value of the last field and length($field); some of the records showed length of 6 although only 5 z's. when i look at file in text editor, there are no trailing spaces.i put cursor at end of line and there was no space after last z.
it's only happening in one db.
pulling my hair out! any suggestions?
i listed all the records and included value of the last field and length($field); some of the records showed length of 6 although only 5 z's. when i look at file in text editor, there are no trailing spaces.i put cursor at end of line and there was no space after last z.
it's only happening in one db.
pulling my hair out! any suggestions?