Hiho,
> Von: Sudhakar[SMTP:[EMAIL PROTECTED]]
>
> SELECT sequence.CURRVAL AS CURRVALID FROM DUAL. So I can directly get the
> insertedid using the ResulSet.getInt("CURRVALID");
>
> I assume DUAL is a system table which stores the CURRVAL for the sequence
> generator. Correct me if I am wrong.
>
dual is a dummy Table with exact one row to allow such contstructs
like yours above...
The currval is stored internally and you just query the database to get the
value.
But you cant do this. (only in mysql ;)
select sequence.currval;
So you have to supply a table ... and dual exists in most big databases.
Regards, Mathias
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
