Column with auto numbering?

[abelmiah]

Is it possible to add a column that automatically adds a number sequentially in the field for each new row? I'm trying to make this numeric column stay the same no matter which column I prefer to sort by. This way I can always keep a count of how many rows I have.

XP
00 2.4.1

[squenson]

I believe that this link could help you.

[abelmiah]

When I add the autovalue column, OO gives me an error everytime. Even if I create a new database using the wizard, as the tutorial suggested, the autovalue does not stay "yes" when I go to table design. It set's autovalue to "no". Even if I change it to "yes" again the error shows: "Error while saving the table design - Column constraints are not acceptable in statement [ALTER TABLE "Addresses" ADD "AddressID" INTEGER IDENTITY]"

I don't understand.