Re: How can i get the new vaule of a counter field?

From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
Date: Tue, 13 Nov 2007 06:59:46 -0500

Patrick wrote:

Hi!
It's possible with ADO to get the new value of id field (counter)
after insert?
Now I search new Id with a separated query, but the system is slow.

Thanks (and sorry for my terrible english!)

It depends on the database you are using. We appreciate it when people tell
us up front the type and version of database they are using - it is almost
always relevant. Anyways, if you are using either Jet (Access) or SQL
Server, this should help:
http://www.aspfaq.com/show.asp?id=2174

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

.

References:
- How can i get the new vaule of a counter field?
  - From: Patrick

Prev by Date: How can i get the new vaule of a counter field?
Next by Date: Re: How can i get the "true" name of an aliased field?
Previous by thread: How can i get the new vaule of a counter field?
Next by thread: Re: Error => -2147467259 Could not save; currently locked by another
Index(es):
- Date
- Thread

Relevant Pages

Re: problem with WHERE clause when using ADO and Microsoft.Jet.OLEDB.4
... I am using ADO with Microsoft.Jet.OLEDB.4.0 to connect to the Access97 ... also had tried to convert the database from Access97 to Access2000 ... This email account is my spam trap so I ...
(microsoft.public.data.ado)
Re: FMTONLY problems
... I'm capturing the data using SQL Server Profiler ... Some of my queries are calling the database with FMTONLY every time ... You failed to provide the ADO code that is causing this behavior. ... This email account is my spam trap so I ...
(microsoft.public.data.ado)
Re: Is ADO Dead (3)?
... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
(comp.databases.ms-access)
Re: Is ADO Dead (3)?
... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
(comp.databases.ms-access)
Re: Is ADO Dead (3)?
... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
(comp.databases.ms-access)