Sorry, but this is a new feature! The usage of <table_name>.currval is required to get the last number used for a "DEFAULT SERIAL"-column.you can't use nextval and currval on a table name.
This feature _is_ working in 7.3.0.29, but it does _not_ work in 7.4beta.
Below is what [EMAIL PROTECTED] wrote 14.10.2002 09:33:
>With the next SAPDB version you can get the last serial value via the
>> currval function specifying the table name, i.e.
>>
>> SELECT TEST.CURRVAL INTO ? FROM SYSDBA.DUAL;
>>
>> or easier in a db-procedure
>>
>> VAR currVal integer;
>
>>>> currVal = TEST.CURRVAL;
>
>>next release? even if it is version 7.3.xx?
>>any release scheduled?
This feature is planed for 7.3.0.29 which will be released
in the next 2 weeks.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
