Thank you very much!
Regards
Gianco
Search found 2 matches
- Tue 06 Jan 2009 12:56
- Forum: SQL Server Data Access Components
- Topic: SQL server IDENTITY fields
- Replies: 2
- Views: 2000
- Tue 06 Jan 2009 07:59
- Forum: SQL Server Data Access Components
- Topic: SQL server IDENTITY fields
- Replies: 2
- Views: 2000
SQL server IDENTITY fields
Hello
I would know if is possible to obtain the value of an IDENTITY field assigned to new records created with an "INSERT INTO" statement (given with a TMSQuery/Execute command), immediately after the statement are executed.
I would not use the SELECT MAX(field) query to obtain the new identifier because this kind of records are created very often in a network environment so it's not the most sure solution.
Thanks a lot for anyone can help me
Gianco
I would know if is possible to obtain the value of an IDENTITY field assigned to new records created with an "INSERT INTO" statement (given with a TMSQuery/Execute command), immediately after the statement are executed.
I would not use the SELECT MAX(field) query to obtain the new identifier because this kind of records are created very often in a network environment so it's not the most sure solution.
Thanks a lot for anyone can help me
Gianco