>Hello all,
>
>I never saw something like that ever. Through my application I added a record to an empty table that contains a field that is Auto-Inc. The value of that field on that new record is 0.
>
>How can that be?
>
>I tried to reproduce but couldn't.

Simple. Wrongly used ALTER TABLE / CREATE TABLE

CREATE TABLE bla (i1 I AUTOINC NEXTVALUE 0)
APPEND

this is better for new record / table

CREATE TABLE bla (i1 I AUTOINC)
APPEND

or

CREATE TABLE bla (i1 I)
ALTER TABLE bla alter COLUMN i1 I AUTOINC NEXTVALUE 0
APPEND