🚀 go-pugleaf

Hello all.

How do i insert a new record into a table with an identity field?
Suppose I have the following piece of code:

TADOTable *t = new TADOTable(FOwnerComponent);
try {
    t->Connection = FConnection;
    t->TableName = "workers";
    t->Active = true;
    t->Insert();
    t->FieldByName("name")->AsString = "Mr. Incognito";
    t->Post();
    Id = t->FieldByName("id")->AsInteger;
    t->Active = false;
} __finally {
    delete t;
}

FOwnerComponent, FConnection and Id are some valid variabled I use in the
program...

I open the table named "workers". Let it be

table workers (
    id int identity(1,1) not null,
    name varchar(255)
);

Then assign some name to the "name" field and try to post the changes into
the DB.

I always supposed that it itsn't necessary to assign some value to identity
fields, it's even not possible in plain SQL, AFAIK... And so I hoped that
the insertion will succeed.

Then, to ruin all my hopes, ADO simply said, "You can't  assign NULL value
to id field. INSERT failed... blah-blah-blah." I know I can't assign NULL,
or even any other value, to an _identity_ field,
but ADO thinks I must, and it shouldn't be NULL... Weird.

After all, I'm kind of puzzled. How do I insert a new record into a table
with an identity field using TADOTable? Is it possible at all?

Any help welcome. Thanks in advice...

See you,
Andrey.

--- Find out what you can do.