Add Autonumber to a table! 1

[JojoKa]

Hi,
How can add an autonumber to an existiing table? Thanks so much in advance
Joseph

 

[PHV]

something like this ?
ALTER TABLE myTable ADD COLUMN myID COUNTER(1,1) CONSTRAINT PrimaryKey PRIMARY KEY;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JojoKa]

Worked. Thank you very much for your quick answer.

Joseph

 

[leonepaolo]

Hi,

I get Run-time error '3090'

I've tried it a variety of ways. I may be missing a Reference for the "COUNTER ...." part of the code as I can add other fields this way.

Any suggestions are appreciated.

Thanks in advance,
Paolo

 

[PHV]

No table may have more than ONE AutoNumber field ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[leonepaolo]

Hi PHV,

Interesting point and exactly what happened. Does this mean you can only have one?

Thanks,
Paolo

 

[PHV]

Why would you want more than one autonumber field per table ?

 

[leonepaolo]

HI PHV,

I don't. I was just checking, for the future really.

I blew my brains out yesterday trying to use SQL to add a whole bunch of records to a table that had a PrimaryKey. After many hours of failling to attempt to rework the SQL code, I lucked upon a Microsoft MSDN website link informing me that this can't be done.

I take it that neither of these can be done?

Thanks,
Paolo

 

[PHV]

I take it that neither of these can be done?
neither of WHAT ?

 

[leonepaolo]

Hi PHV

1. I take it that more than one AutoNumber field is not possible, at least through SQL.

2. I take it that many records cannot be added to a table with a PrimaryKey using SQL and the records must be looped into the table.

Thanks,
Paolo

 

[PHV]

1. True (SQL or not doesn't matter)
2. False