You should be able to correct it in your database by modifying the correct row in the field_char table. If all you did was change the field length, then the only change in the data dictionary (that I know of) would be the maxLength column in the field_char row for that schemaid/fielded. Just change that to reflect the actual length in on the database column. If your column is text, make maxLength 0. If your column is varchar, make maxLength the same size as your varchar limit.
Of course, back it up before making the change. And you'll need to cycle AR Server after you make the change in order to make it work. There may be more to it. To verify, turn on SQL logging, create a character field on another form, change its length to 0, then change the length back. Then look at the log to see what it did. Chad Hall (501) 342-2650 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Rondeau Sent: Friday, September 19, 2008 9:07 PM To: [email protected] Subject: Changed field size on a Field Hi All, Basically we updated a field size through the Admin Tool. This was a character field. The SQL DB froze up and the job crashed. So my question is this we have a Z temp field that was created and since the orginal field is nvarchar and the new update makes it a ntext field. Since this Z field is still there and not completing. We are unable to use the field or update the field in anyway. Is there anyway to clean up this Z temp field with out any restore? Running 7.0.1 patch 2 Thanks for you time Tim ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ************************************************************************* The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you. ************************************************************************* _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
