I'm sorry, i couldn't find than in your list-archives. Thanks, Mit freundlichen Grussen
Alexei Livchits e-mail: [EMAIL PROTECTED] > -----Ursprungliche Nachricht----- > Von: Zabach, Elke [mailto:[EMAIL PROTECTED]] > Gesendet: Donnerstag, 26. September 2002 17:23 > An: 'Alexei Livchits'; [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Betreff: RE: ODBC, serial data type, adding new > row, getting new id > > > Alexei Livchits wrote: > > > Hi, > > i have understood your first post too, but i > want to know, > > whether this problem is a bug. > > > > Mit freundlichen Grussen > > > > Alexei Livchits > > e-mail: [EMAIL PROTECTED] > > As mailed several times: we agree that this is a > missing feature. > It is on our to-do-list. There is no > time-schedule available so far. > > Elke > SAP Labs Berlin > > > > > > -----Ursprungliche Nachricht----- > > > Von: Carl Olivier [mailto:[EMAIL PROTECTED]] > > > Gesendet: Donnerstag, 26. September 2002 16:59 > > > An: [EMAIL PROTECTED]; Alexei Livchits; > > > [EMAIL PROTECTED] > > > Betreff: RE: ODBC, serial data type, adding new > > > row, getting new id > > > > > > > > > Let me be more explanatory: > > > > > > you create a SEQUENCE object in your database > > > using SQL as so: > > > > > > > > > CREATE SEQUENCE RESOURCE_SEQ INCREMENT BY 1 START > > > WITH 1 NOMINVALUE > > > NOMAXVALUE NOCYCLE NOCACHE ORDER > > > > > > Then, when you want a unique number to keep a > > > handle to, while using it in > > > an insert you: > > > > > > SELECT RESOURCE_SEQ.nextval from dual > > > > > > This will return a result set where you can do a > > > rs.getInt(1) (or whatever > > > language you are using). This will be the number > > > to use. It will also have > > > incremented the next available number for you. > > > > > > You can then store that number in a variable and > > > use it in your insert > > > > > > E.G. (using Java) > > > > > > int i = rs.getInt(1); > > > > > > String sql = "INSERT INTO mytable VALUES (" + i + ")"; > > > > > > //then run your insert or whatever. > > > That make sense? > > > > > > Carl > > > > > > > > > > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED]]On > > > Behalf Of Carl Olivier > > > Sent: 26 September 2002 04:43 PM > > > To: Alexei Livchits; [EMAIL PROTECTED] > > > Subject: RE: ODBC, serial data type, adding new > > > row, getting new id > > > > > > > > > You should loom into the sapdb SEQUENCE objects. > > > This is how I do it. > > > > > > Carl > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED]]On > > > Behalf Of Alexei Livchits > > > Sent: 26 September 2002 04:26 PM > > > To: [EMAIL PROTECTED] > > > Subject: ODBC, serial data type, adding new row, > > > getting new id > > > > > > > > > Hi, > > > i have a problem: after inserting a new line with > > > addnew/update, I need the new ID. With ms ACCESS is it > > > simple: I just get a new id. But with sap db is it > > > impossible. Here is my code: > > > -------------------------------------------------- > > > ---------- > > > ---------------- > > > oRs.Open "SELECT * FROM TESTTABLE", > > > Conn, 1, 3 > > > oRs.AddNew > > > oRs("TESTCOLUMN") = False > > > oRs.Update > > > NewID = oRs("BLOCK_ID") > > > ' NewID is empty > > > -------------------------------------------------- > > > ---------- > > > ---------------- > > > > > > at the moment i do it in this way: > > > -------------------------------------------------- > > > ---------- > > > ---------------- > > > oRs.Open "SELECT * FROM TESTTABLE", > > > Conn, 3(!), 3 > > > oRs.AddNew > > > oRs("TESTCOLUMN") = False > > > oRs.Update > > > oRs.Requery > > > oRs.MoveLast > > > NewID = oRs("BLOCK_ID") > > > -------------------------------------------------- > > > ---------- > > > ---------------- > > > This way is not ideal. > > > > > > > > > > > > Best regards, > > > > > > Alexei Livchits > > > e-mail: [EMAIL PROTECTED] > > > > > > _______________________________________________ > > > sapdb.general mailing list > > > [EMAIL PROTECTED] > > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > > > _______________________________________________ > > > sapdb.general mailing list > > > [EMAIL PROTECTED] > > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > > > > _______________________________________________ > > sapdb.general mailing list > > [EMAIL PROTECTED] > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
