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.
