Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wolfnero
Starting Member
6 Posts |
 Posted - 2007-04-12 : 05:30:21
|
I'm new of this forum. I insert a record into an MSAccess database via ODBC (in a MFC program), a record whit an automatic counter. I would like to know if exist something to have this counter value with the insert. (Sorry for my English)  |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-04-12 : 05:39:31
|
| The counter value is created DURING the insert. Not before and not after.You can always do a SELECT MAX(Col1) FROM Table1 afterwards.Peter LarssonHelsingborg, Sweden |
 |
|
|
wolfnero
Starting Member
6 Posts |
Posted - 2007-04-12 : 11:35:04
|
| Than i need a second process: first whit the insert and than the select to know the field value.... |
|
|
|
|
|
|
Read a counter value