by gamma.. » Wed, 22 Mar 2000 04:00:00
I'm working on a program that needs to add a record to a SQL Svr 7 table
that contains an identity column. I'm using the rs.AddNew ... rs.Update
syntax on an ADO recordset. How can I learn the identity value of the
new record right after the Update statement fires and the record is
inserted into the SQL table?
Thanks very much for any help you can offer!
- Jim
by Dennis Che » Thu, 23 Mar 2000 04:00:00
> I'm working on a program that needs to add a record to a SQL Svr 7 table
> that contains an identity column. I'm using the rs.AddNew ... rs.Update
> syntax on an ADO recordset. How can I learn the identity value of the
> new record right after the Update statement fires and the record is
> inserted into the SQL table?
> Thanks very much for any help you can offer!
> - Jim
by José Pedr » Sat, 25 Mar 2000 04:00:00
example
rs.update
variable = rs!(identity value)
rs.close
> I'm working on a program that needs to add a record to a SQL Svr 7 table
> that contains an identity column. I'm using the rs.AddNew ... rs.Update
> syntax on an ADO recordset. How can I learn the identity value of the
> new record right after the Update statement fires and the record is
> inserted into the SQL table?
> Thanks very much for any help you can offer!
> - Jim
1. Get Identity Field Value ADO SQL Server
I use an Identity Field in a table in SQL Server 7. The field is
autoincrement.
How can I get the value of this field after an adnew and update method,
without executing an SQL query on my table ?
Can a stored procedure help ?
I uses ADO 2.5 in VB6 with SQLOLEDB provider.
Thanks,
Ulysse
2. Exchange 5.5
3. Attempt to insert duplicate identity values in table (has identity and key fields)
4. Easy? Please Help: SQL Server 6.5 Alerts - don't seem to work right
5. Getting the value of an autoincrement or identity field during an sql insert
6. Urgent!
8. Getting back an identity field value after an insert SQL statement
9. SQL Server 7 - How do you get Identity value when doing an insert
10. Get identity column value before phisically insert a row in SQL Server 2000
11. Incrementing Next Field's Value Based Upon Prior Field's Value
12. ADO does not return SQL Server Identity value