[JBoss-user] How to generate the sequence number in Hypersonic

[Pifen Ellwood]

Hi,
This may be a very stupid question. I use Auto Increment condition on my ID
column and got the error message.
Is there any function such as nextval in hypersonic to generate the sequence
number?
 CREATE TABLE sometable (
       name                 VARCHAR(20) NULL,
       ID                        INT  AUTO INCREMENT NOT NULL,
       Type                    VARCHAR(20) NULL,
       PRIMARY KEY (ID));

Thanks
Pifen Ellwood


_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user