Hi
I've got in my DB a sequence with increment 1
When i use this code :
req = "Select Id.nextval as Id_Bis from Table"
rs.open req, conn
If rs.bof and rs.eof then
Id = 1
Else
Id = rs("Id_Bis")
End If
My Id is not incremented by 1 but by then rs.recordcount.
Or this code is ok in oracle 8!
Is Anyone have suggestion to resolve my pb?