Subject Re: Fix SEQUENCE value
Author Adam
--- In firebird-support@yahoogroups.com, "zaher dirkey"
<zaherdirkey@...> wrote:
>
> In firebird 2 can i do this
>
> ALTER SEQUENCE posts_id RESTART WITH (SELECT MAX(id) FROM posts)
>
> and how to fix it in one query, may be i use "execute block"?
>

From Firebird 2 RC 5 release notes under General Notes:

"4. It is fine to use the Firebird-devel list to report a problem with
the beta or to ask for more information about a new feature. Do not
use the Firebird-support list to raise these issues."

However I must point out your first question seems to be one that a 5
second experiment could determine if you have Firebird 2 installed,
which I don't.

Adam