If i have a database, and have a field that has an auto number, will that increase when i add records using a form online?
JoeM6
JPMJR11@aol.com
JoeM6
JPMJR11@aol.com
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Database and Auto Numbers
- Thread starter JoeM6
- Start date
yes.
i use ms-sql. many tables have a 'identity' field (= auto-num). You must use an INSERT INTO with a fieldlist. In this fieldlist you must NOT list your identity/autonum field.
With MS-SQL you can query the last identity number with a special system variable: @@IDENTITY
br
Gerard
i use ms-sql. many tables have a 'identity' field (= auto-num). You must use an INSERT INTO with a fieldlist. In this fieldlist you must NOT list your identity/autonum field.
With MS-SQL you can query the last identity number with a special system variable: @@IDENTITY
br
Gerard
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question