Addnew with oracle
I am using Oracle. I have a table with colume ID. I want to add sequence number to my ID when ever new record is added to the table. I have also created sequence in oracle.
Can someone help me on how to add a new record with ID incremented based on sequence in Oracle.
My code (without ID) is
Set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = dbconn
rs.CursorType = adOpenKeyset
rs.LockType = adLockOptimistic
rs.Source = "SHAHP.Project"
If Not IsEmpty(Request.Form) Then
rs("title") = Request.form("title")
rs("owner") = Request.form("owner")