Does anyone know why I can retrieve the value of an AutoNumber field in Access before updating the recordset, but I can't do the same in SQL server.
Example:
************************
In Access this works:
rs.AddNew
iID = rs.Fields("ID" '*** AutoNumber field
rs.update
***********************
In SQL Server it returns a NULL. I have to update the recordset first.
Example:
************************
In Access this works:
rs.AddNew
iID = rs.Fields("ID" '*** AutoNumber field
rs.update
***********************
In SQL Server it returns a NULL. I have to update the recordset first.