Technically, yes, you can. You can go into the DB and reset the NextID variable for that form. However, if it's a form that's being used for entry (vs a config form), there's a good chance that numbers already exist that exceed 7002. If so, you'll get a Unique Index error when the next incremented Entry ID see that a record already has that number.
I would ask what you would gain from such an exercise vs. the effort it would take you to gain it. Decide which is worth more to you. Rick Cook On Mon, Nov 3, 2014 at 7:59 AM, Sinclair, Keith <[email protected]> wrote: > ** > > Okay, have an unusual request. > > > > If there’s a missing block of Request ID numbers, can these be recovered? > Example, a request started at 6001. Then someone uploaded a CSV and then > deleted the records – not me, but someone in another department did this. > So the next legitimate request ID is 7002 or something like that. > > > > Can the numbers that were deleted, 6002 – 7001, be reused? When I first > started out on Remedy, the answer was not really. Not sure if anything has > changed in the years/versions since then. > > > > Specs: > > ARS 8.1 > > Oracel12b DB > > > > *Keith Sinclair* > > *Remedy Development* > > *ShopperTrak Chicago USA* > > O: 312.676.8289 | M: 630.946.4744 > > *[email protected] <[email protected]>* | @shoppertrak > > www.shoppertrak.com > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
