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
