How do I make a column autoincrement?

[pederalm]

I use the Pervasive 8.0 Table Designer. I want to set the first column 'id' to autoincrement. How do I do that?

 

[mirtheil]

Are you trying to modify an existing table or create a new table?


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[pederalm]

Create a new table. I'm using the Table Designer but can't find a function to make a column autoincrement.

 

[mirtheil]

Are you using Table Designer or Create Table Wizard? If you're creating a new table, use the Create Table Wizard or SQL statements. An Autoincrement field is called Identity in SQL.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[pederalm]

I had a table without any records that I'm tried to edit in Table Designer, but the Data Type Identity weren't present in the drop down list. But when I use the new table wizard the data type Identity are present. Strange but now I (or you) have solved the problem.

Thanx