CREATE QUERY WITH AUTONUMBER 1

[100dtl]

create table messages(id int,password text,ipaddress text)

I would like the first column ID to be autonumber.. is this possible? o

 

[r937]

create table messages(id int counter
,password text,ipaddress text)


rudy

http://r937.com/

 

[KenReay]

Hi

Yes you can, although I cannot recall how out of my head, see

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acfundsql.asp

for starters

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[100dtl]

r937.. did'nt work

 

[nicsin]

I think it's:


create table messages(id int autoincrement, password text,ipaddress text)

 

[PaulBricker]

The correct syntax is just counter.

create table messages(id counter, password text,ipaddress text)

This will return the id as Autonumber.

Paul

 

[100dtl]

Correct.. nice one!

 

[thegad]

Other solution :
create table messages(id AUTOINCREMENT,password text,ipaddress text)