CPB Mailing List

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SQL type for Autoincrement field



I have a problem with not being able to initialise an autoincrement 
field in one of my tables. So I have decided to drop the table and 
recreate it (I want to clear all the records anyway) using SQL.

So I do 

drop table "tablename.db";

create table "tablename.db"
(
	field1 SMALLINT,
	field2 SMALLINT,
	field3 <???>
)

where field 3 should be the autoincrement field.

My question...what is the SQL type for an autoincrement field in
Paradox tables ?


W Komornicki's Home Page | Main Index | Thread Index