🚀 go-pugleaf

Does your TADOTable have a fields list? If so check the AutoGenerateValue
property of the ID field is set to true and set any other properties which
indicate that its value will be set by the server?

BM

"Andrey Subbotin" <e-ploko@mail.ru> wrote in message
news:3bc2e62f$1_2@dnews...
> 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.
>
>
>