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] > -----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
