AutoNumber Field Is Not Incremented, Doing an Addnew

[Guest_imported]

Hello,
I am developping an application with an Oracle Database.

When I'm doing an addnew on a recordset, after the update, the identifying field is not incremented, it is equal to 0 and not the right value.


exampleID is an autonumber)
rs.addnew
rs("refequipement&quot=Request(refequipement)
rs.Update
response.write(rs("ID&quot)

and when I execute this, it writes: "0"
The only solution I know is to close the recordset and to re-open it.But it doesn't meet my quality standard.
If you know another solution, please tell me.
Thanks.

 

[snowboardr]

Not sure; just wanted to ask about Oracle? How is it? speed wise.. etc setting it up ? Is there a gui for it? Any of that type of info would be nice. Sorry for so many questions, but im curious, and want to try out every database out there. www.vzio.com

/

 

[rac2]

What type of cursor have you specified?

A dynamic cursor is required to see changes in the database without resynchronizing the cursor.

rs.CursorType = 2 'adOpenDynamic

or

rs.CursorType = 1 'adOpenKeySet
. . .

rs.Resync