Hi Ron, I had handled such situation in earlier assignment. There to avoid huge series of leading zeros we had limited size of request ID to 6.
There are few checks you will have to do 1) Check the "Input length" of this field. 2) Check column width of C1 at the data base level. If at database level it is 15, then you can change input length to 7 or whatever number up to 15. Since the data base is already capable of handling larger data this change has least data. If both these have length as 6 then the table needs to be altered, which may create temporary load on the system. In either case it is recommended that you do this activity in the lean time. As soon as you save the form the new ID will be generated with the new length. If you have not hit the limit you will see leading zeros. It does not affect any old records. The only visible problem is that since the request ID is stored and handled as a character the ones appended with zero comes on the top. Example 0967991 (first with 7 digits) 0967992 0967993 967988 967989 967990 (last with 6 digits) It would be a good idea to inform user community about this apparent incorrect ordering of tickets. Later on you can append leading zeros to old cases by writing direct SQL at the data base level. However you will have to take of H and B table. Best Regards, Uday Joshi Delivery Manager - BSM Tech Support Technology Infrastructure Services - BSM Unit ------------------------------------------------------------------- Wipro Technologies, Hinjewadi, Pune 411057 India Tel: +91 20 39104092 VOIP 842-5103 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Ron [TBC] Sent: Friday, September 12, 2008 08:23 PM To: [email protected] Subject: Increasing Entry ID Length ** Hi all, Wanted to bounce this off the group to see if there is an easy and safe way to increase the size of the Entry-ID Field (1). We are currently at a length of six on the Homegrown helpdesk app, and after 10 + years using it, we are about to roll over ID# 999999. What I want to do is to increase it to a length of 8. Problem is that the existing ID's do not pad out to the full 8 digits. Is there any utilities out there that makes this change easy and simple to do. I am pretty sure I can do this by exporting the data and massage it and reimport it, but looking for an easy way to do it. Thanks in advance. ARS 6.3 P.20 Win 2K3 SQL Server 2000 Thanks, Ron Smith Remedy/Web Developer Providence Health & Services OR [EMAIL PROTECTED] 503-216-7866 DISCLAIMER: This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<<ATSLogo.JPG>>
