In my base there is a table "Companies", with "ID" column inside (of course, there are other columns too, but it doesn't matters now).
The "ID" column is set as "INTEGER", PRIMARY KEY and "Auto-increment"
Now, the problem:
I'm trying to insert data into this table.
I typed in the firs record - everything is OK. It received ID = 0. But, when I try to insert a secound column, I receiving an error:
Code: Select all
[b]Violation of unique constraint SYS_PK_53: duplicate value(s) for column(s) "ID" [/b]
feel free to correct my english