[Hsqldb-developers] Re: SEQUENCES DO NOT WORK IN HSQLDB 1.8.0.4

[fredt]

You need to use:   SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SEQUENCES   Please read the docs on SCHEMA and SEQUENCE support. Also note that you do not use the above query in order to access the sequences. The _expression_ used is "NEXT VALUE FOR a_sequence"   Fred ----- Original Message ----- From: Nitin Uchil To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: 20 April 2006 12:32 Subject: SEQUENCES DO NOT WORK IN HSQLDB 1.8.0.4 Hi Fred:   Looks like sequnces still do not work in version 1.8.0.4. I tried:   SELECT * FROM SYSTEM_SEQUENCES   and it gives a table not found error. We are migrating our databases from Oracle and mySQL and this is one thing that is holding us back. Nitin Uchil