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

[Nitin U. <nit...@gm...>]

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 <fr...@us...> wrote:
>
>  You need to use:
>
> SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SEQUENCES
>
> Please read the docs on SCHEMA and SEQUENCE support. Also note that you d=
o
> 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 <nit...@gm...>
> *To:* fr...@us... ;
> hsq...@li....
>  *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
>
>
>


--
Nitin Uchil
(734)945-6463