Confirm/commit insert in ADP project

[ivan.nesic]

I'm working on ADP (access/SQL server) project and I have bounded form
to a Sql server database. How can I commit or confirm insert in table
of new record when user clicks on confirm button? Actually I want to
confirm creation of identity field in that table so I can insert it
like foreign key in other table. Refreshing whole table is not good
solution, too slow.

Thx Ivan.

[David Lloyd]

Ivan:

I am not sure of your exact setup, so I will just make some general
comments. Generally, when doing an insert to a table with an identity
field, you use the SELECT @@Identity (or Scope_Identity() or
Ident_Current(), depending on your circumstances) to gain the value of the
newly created identity value. The following KB articles give more
information on the @@Identity value.

http://support.microsoft.com/default...b;en-us;233299
http://msdn.microsoft.com/library/de.../en-us/tsqlref

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
<iv********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I'm working on ADP (access/SQL server) project and I have bounded form
to a Sql server database. How can I commit or confirm insert in table
of new record when user clicks on confirm button? Actually I want to
confirm creation of identity field in that table so I can insert it
like foreign key in other table. Refreshing whole table is not good
solution, too slow.

Thx Ivan.