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 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
