Bola,
If you know the specific SQL command you can do this in an Active Link. For example (SQL Server) - UPDATE ARSchema SET nextId = 1 WHERE [name] = 'HPD:HelpDesk' Stephen Remedy Skilled Professional ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On 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 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<<image002.gif>>
