"Sven K�hler" schrieb

> select t.currval from sysdba.dual
>
> this doesn't work and the select statement throws the following error:
>    General error;-4020 POS(8) Unknown sequence name:T
>
> very strange ...  doesn't 7.4beta support that yet? 7.3.0.29 did support
it.

Hi Sven,

you can't use nextval and currval on a table name. You have to define a
sequence. Try this:

create sequence t

select t.nextval from dual

select t.currval from dual

Ulrich




_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to