ansaurus

Question

is there a way to do SELECT SCOPE_IDENTITY() in ADODB?

Answer 1

+2 A:

No, there is not.

You should make an explicit INSERT statement followed by a call to SCOPE_IDENTITY in the same batch.

Quassnoi 2010-08-20 16:59:34

thank you very much i really appreciate your time

I__ 2010-08-20 17:02:04

@quassnoi: is what guffa saying correct?

I__ 2010-08-20 17:09:00

@op: yes, though it's not actually about `SCOPE_IDENTITY`.

Quassnoi 2010-08-20 17:09:57

are you sure guffa's answer this is OK in a multiuser environment? if so, then why dont i just use it?

I__ 2010-08-20 17:10:57

why doesnt this have @ before the values? http://msdn.microsoft.com/en-us/library/aa933206(SQL.80).aspx

I__ 2010-08-20 17:13:29

@op: you can use it, as long as you open your recordset with `adOpenStatic`. Your question was about `SCOPE_IDENTITY`.

Quassnoi 2010-08-20 17:16:25

im sorry what does that mean adopenstatic?

I__ 2010-08-20 17:19:31

http://stackoverflow.com/questions/3533263/scope-identity-vs-rs-fields

I__ 2010-08-20 17:20:17

Answer 2

+2 A:

After you have executed the Update command, the identity will be placed in the corresponding field in the recordset. You can read it from there.

Example:

id = .Fields("id")

Guffa 2010-08-20 17:04:56

thank you very much. are you sure this is OK in a multiuser environment?

I__ 2010-08-20 17:10:17

@I__: Yes, you have an open connection to the table, so the value is read from the actual record rather than by calling a function.

Guffa 2010-08-20 17:18:15

the answer below says: you can use it, as long as you open your recordset with adOpenStatic ---how do i know if i an opening it this way?

I__ 2010-08-20 17:19:52

http://stackoverflow.com/questions/3533263/scope-identity-vs-rs-fields

I__ 2010-08-20 17:21:01

@I__: The third parameter in the call when you open the recordset is the cursor type, and the adOpenStatic constant has the value 3, so if you use `rs.Open sql, conn, 3` then you are using a static cursor.

Guffa 2010-08-20 18:18:31

ansaurus

tags:

views:

answers:

is there a way to do SELECT SCOPE_IDENTITY() in ADODB?

related questions