Re: 'Nother question

Frank Schönheit - Sun Microsystems Germa ny <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]> 
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 <column name> RESTART WITH <new value>

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 -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.