Dag Liodden wrote : >I have a dbproc that among other things inserts a new row into a table >with an id generated from a sequence.
>Now I do: >select owner.seqname.nextval from table; >fetch first into :id; >insert into table > (id, > .. > .. > ) values ( > :id, > .. > .. > ) >ID is declared out, of course. >In Interbase, you can user id = gen_id(seqname, step) in stored procs. Is >something like this possible in sap? It is more convenient and the method >I use now seems like a quick hack. :) you can assign the result of seq.nextval directly to a variable : set id = owner.seqname.nextval; Thomas --- Thomas Anhaus SAPDB, SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
