Thanks for the reply. Turns out that there was more than one field getting the data pushed to it. I increased the size of the first one, which generated the error with the field id in it, and the second hidden one was the one causing the SQL error. Not sure why it wasn't the same error message, but it works.
Thanks again. Jackie -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Peter Romain Sent: Monday, November 26, 2007 12:26 PM To: [email protected] Subject: Re: Changing field size Is there any workflow pushing the field to other forms? If so then you'll have to increase the field length there too. > List: > > > > I have a form that has been used for 7 years. In it a field for email > address is set to 30 characters. We have an employee whose email > address is 32 characters and therefore will not fit. > > The error she received originally was "ARERR [306] Value does not fall > within the limits specified for the field : (max length - 30) : > 536870931" Understandable. > > When I increase the size of the field, the error changes to "ARERR [552] > Failure during SQL operation to the database : ORA-01401: inserted value > too large for column > > Less than 32 characters the error mentions the field id, greater than 32 > characters, it's an SQL problem. > > > > Its just a character field, nothing special. > > > > Any help is appreciated. > > > > ARS 6.03 > > Oracle 9i > > Solaris 9 > > > > Thanks. > > Jackie Morris > > EasyLink Services > > [EMAIL PROTECTED] > > 732-652-3611 > > > > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
