Thanks Fred:
WIll inform the posts that I have found.
What is the SEQUENCE_CATALOG field? When I added a sequence using:
CREATE SEQUENCE utility_content_SEQ
AS INTEGER
START WITH 1
INCREMENT BY 1;
I get null as the SEQUENCE_CATALOG.
On 4/20/06, fredt <[EMAIL PROTECTED]> wrote:
I'm not aware of the groups where such questions have been raised. If you know, please let them know.Fred----- Original Message -----From: Nitin UchilSent: 20 April 2006 14:02Subject: Re: [Hsqldb-developers] Re: SEQUENCES DO NOT WORK IN HSQLDB 1.8.0.4
Thanks Fred - it works.But in several use groups this question about SEQUENCES not working has popped up perhaps because they do not know that INFORMATION_SCHEMA needs to be prepended.Best Regards.Nitin
On 4/20/06, fredt <[EMAIL PROTECTED] > wrote:You need to use:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SEQUENCESPlease 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 UchilSent: 20 April 2006 12:32Subject: 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_SEQUENCESand 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
--
Nitin Uchil
(734)945-6463
--
Nitin Uchil
(734)945-6463