This is for oracle but must be similar for sql

*Type this statement to update the id*



update aradmin.arschema set nextId = *011848* where name = *'CHG:Change*';


commit;


*Type this statement to find next ID*



select name, nextId from aradmin.arschema where name = *'CHG:Change'*;





Susan


On Wed, Dec 17, 2008 at 8:10 AM, Timothy Rondeau <
[email protected]> wrote:

> Hi,
>
> Hoping someone can refresh my memory.  I want to start a new form at a
> higher request ID than 1.  So say 1000, I know there is a command to do
> this.
>
> We are on Windows 2003, SQL 2000.   ars 7.0.1
>
> Thanks
>
> Tim
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>

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

Reply via email to