Scott Murray wrote: > I get an error when I try this: > > update tbl_vendor set vendor_id = ROWNO + 1 > > Is there a way to us the ROWNO in a calculation such as this?
Perhaps there is a misunderstanding: ROWNO is a feature to number resultrows in a resultset. Therefore I do not understand what the meaning of your update should be. Or are you looking for a number generator (see SERIAL, create sequence statement or HOWTO about numbergenerators) ? Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
