Hi,

I was just wondering if you guys have experience with SELECTING PREVVAL from a sequence object. It seems that evertime I start a new session and directly try to get the prevval from the sequence object it throws an exception saying that the sequence object has not been initialized.

Any suggestion on how to solve it?

J

Try reading the manual

how you created the Sequence?

try the one: CREATE SEQUENCE seq_test1 AS INTEGER START WITH 1 INCREMENT BY 1

and then query for PREVVAL for seq_test1.

You need to call NEXTVAL before PREVVAL.