i have a table in access2003
when a new record is inserted into the table(from windows appln) , variable counter should incremented by 1
now the problem is
how to implement this and
where to store the counter variable in database
insertion problem
Hot Topic
- How i can disable pinvoke?
- Opening mdb database at runtime
- Access - cannot execute a simple "Update" statement.
- Preventing user from typing in a datagrid cell ?
- Using Bluetooth with VS 2005 beta 2
- Undo operation exception
- 'System.OutOfMemoryException'
- to use the NetworkStream::Write() for synchronous sending!?
- Unhandled exceptions will always be fatal to a process?
- NNTP test post
.NET Development
- Stepping through a unit test generates MDA FatalExecutionEngineError
- Right way to Read & Write Diffgram from a Typed DataSet
- Lightweight DataTable for Middleware
- write files to cd/dvd
- How do I get a .NET TextBox to implement MY OWN INTERFACE
- Saving a wav file in sqlsever
- Xml.XmlDocument.Load problem and don't know why???
- Data Access problem
- Installing .. advpack.dll
- Dispose and Application Lifetime Objects
insertion problem
has2nk
PhoenixRises
sir im in urgent requirement for this problem
what is this IDENTITY field
pls reply
thanku
Urano
> After record inserted, you could call SELECT SCOPE_IDENTITY() statement to get this value from SQL Server or SELECT @@IDENITY ina case of Access database
Actually, SELECT @@IDENTITY is working very well for MSSQL Server database as well.
i-developer
Sijin Joseph
sir
can u tell me how to implement this identify field in access database
pls reply