Re: 'Nother question

Thanks for the reply! I'm distracted with other things and will get back to 
this.

Cheers,

--Paul T.

Frank Schönheit - Sun Microsystems Germany <[email protected]> wrote: Hi Paul,

> Also, in my form I have an 'auto_encrement' field to create a record/page number
> for  my form. How can I reset this value once it starts incrementing? It started
> at 0 and I tried to delete it to have the first record be number 1. Now the new
> numbers are being incremented off of a value that does not reflect the number
> of records/pages.

According to http://hsqldb.org/doc/guide/ch02.html#N104AE,

  ALTER TABLE ALTER COLUMN  RESTART WITH 

should do the job.

Ciao
Frank

-- 
- Frank Schönheit, Software Engineer         [email protected] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Database                   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



 
---------------------------------
Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers.