Bola, Build a View form on your AR Server, against the arschema table.. If you are on Oracle, the table names are case sensitive and will have to be in all caps.
On this view form, map the name, schemaid and nextid fields on the form. Make sure you have the name and schemaid fields as non-editable. The nextid field should be editable. 1) Delete all the entries on the form that you want to reset the nextid. 2) Open the view form you have created and search for the record for that form by using the name column. 3) Modify the nextid value and save the record. Note that if you do not delete all the entries in that form, and reset the nextid value, you risk getting unique index errors. Warning: Please be careful when you modify anything on the arschema table. This is a meta table and if working directly on it, you do not want to risk breaking any internal relationships. When you create a view form to that table, you basically will have the ability to modify any data, but doing so you will risk breaking internal relationships if you are not careful. Use with care... Cheers Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Oyefeso, Bola Sent: Monday, November 05, 2007 11:41 AM To: [email protected] Subject: Re: Starting a new ID ** Obviously, this has to be done at the database level. I am not the database administrator. Is there a way to do it on my end without contacting the administrator. Thanks. ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, November 05, 2007 9:38 AM To: [email protected] Subject: Re: Starting a new ID Bola, Find out the schema ID of that form, you will be able to find this from the table arschema.. Corresponding to that row in the arschema table, modify the nextid value to 1. Also make sure that you have deleted all related tickets in case you have related information stored in other tables. Reset those ID's as well. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Oyefeso, Bola Sent: Monday, November 05, 2007 9:33 AM To: [email protected] Subject: Starting a new ID ** Hello everyone, I created some tickets on a new application that I am implementing tomorrow. I will be deleting all these tickets, but I want the user to begin with Case ID “00000000001”. Any quick idea on how to do this? Thanks all. Bola Oyefeso No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.22/1111 - Release Date: 11/5/2007 4:36 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<<image001.gif>>
