Very Computer

Hello

I am using RDO with SQL server.  When I need to insert a record and grab the
identity field I was doing it like this

rs.addnew
rs!field1 = "whatever"
rs.update
rs.bookmark  = rs.bookmark.lastmodified
id = rs!ID

Sometimes this worked, sometimes it didn't.
I know there is a way to create a stored procedure which will return the
newly created identity field but I don't know its syntax.  Does anyone know
how to do this.
Also, is there a way to return a value using an access query def.

Thanks
Vince Varallo

I am using something like this :

Create Procedure sp_InsertValueReturnIdentity
As
 SET NOCOUNT ON INSERT INTO tblTest(colName, colName)

It returns a variant (i think) that contains the ID.

I hope this help you
Mikael

Vince Varallo skrev i meddelandet ...