Creating an auto incrementing column with ASP

maniaccoder · #1 (**permalink**) 10-11-04, 16: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, 20: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, 17: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, 20: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, 06: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!