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___

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

<<image001.gif>>

Reply via email to