Thank you, we are currently creating this in the test system and will let you know.
Tim ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, September 23, 2008 10:35 AM To: [email protected] Subject: Re: Changed field size on a Field You will also need to alter the T table, to change the length of the field there to actually change the description of the table. Since it created an ntext field, and has still kept the nvarchar you will need to copy the contents from the nvarchar field into that newly created ntext field, then alter the table to drop the nvarchar field and then rename the ntext field to C followed by the ID that the field originally had.. You do not need to start the AR Server.. running arsignal -g <hostname>:[port] should re read the newly modified definitions.. Like Chad suggested, backup the database before you do anything so you have a recovery point in case we missed something.. Joe ----- Original Message ---- From: Hall Chad - chahal <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, September 23, 2008 10:02:50 AM Subject: Re: Changed field size on a Field 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 <http://www.arslist.org/> Platinum Sponsor: www.rmsportal.com <http://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. ************************************************************************ * __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
