By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,133 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

Confirm/commit insert in ADP project

P: n/a
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.

Dec 7 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Dec 9 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.