Notice that if you specify a value for the serial field in your insert statement, no serial is generated but the specified value is inserted. In this case, the above statement returns an error (-2029:CURRVAL is not yet defined in this session)
would would be returned here? (id is the serial-column)
insert into my_table(text) values ('test1')
insert into my_table(id, text) values (2, 'test1')
select my_table.currval from sysdba.duali think 1 will be returned, instead of the error.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
