Creating an auto incrementing column with ASP

maniaccoder · #1 (**permalink**) 10-11-04, 15:42

Hello!

I wanna create an auto incrementing column with ASP. The code that i use to do this is below. This code don't works. But why?! I couldn't understand... Is there anyone who knows that how can I do this operation?

Code:

			SQL = "ALTER TABLE [" & table_name & "] "
			SQL = SQL & " ADD COLUMN [" & field_name& "] "
			SQL = SQL & " adInteger "
			SQL = SQL & " IDENTITY "
			conn.execute SQL

P.S. This code works very good. It creates a column as integer and don't create any errors on ASP page but the created column isn't auto increment!

rokslide · #2 (**permalink**) 10-11-04, 19:18

Shouldn't it be more like....

Code:

SQL = "ALTER TABLE [" & table_name & "] "
SQL = SQL & " ADD COLUMN [" & field_name& "] "
SQL = SQL & " adInteger "
SQL = SQL & " NOT NULL IDENTITY (1, 1) "
conn.execute SQL

but it would really depend on what database you were working with (I am assuming it is MS SQL.

maniaccoder · #3 (**permalink**) 10-13-04, 16:42

Ah, sorry! How could I forget to saying the database type which I work on!

I use Microsoft Access, similarly with all most of ASP coders. Thanks you for your answer(s).

I tried your code and it gives an error on ALTER TABLE state. :'(

rokslide · #4 (**permalink**) 10-13-04, 19:50

Okie, had a look around and I can't find any sql to help you, but this article may be of use....

http://imar.spaanjaars.com/QuickDocI...QUICKDOCID=143

maniaccoder · #5 (**permalink**) 10-14-04, 05:11

Thanks for your interest with my problem. The article that you referred to me is very usefull and it solved all my problem. Code is working very clearly! Ugghh!

Internet Services

Web Development

Digital Marketing

Consumer Tech