Insert and Identity columns...

Michael J. Austin

Delphi Developer

Wed, 19 Nov 2003 10:24:47 GMT

Insert and Identity columns...

All:

I have SQL Server 7 tables that use identity columns. These columns are not
visible to user input. When I insert and then post, I get an "attempting to
update a non-nullable column with a null value." error. The identity column
is the only non-nullable column. I am using D5, ADO 2.5, and SQL Server 7,
SP1. If I try to manually insert a row with Query Analyzer, of course it
works fine.

BTW, I am using TTables.

It seems that this must be a problem with the TTable component or ADO.

Any help appreciated.

Mike

Michael Rodrigue

Delphi Developer

Sat, 22 Nov 2003 00:11:32 GMT

Re:Insert and Identity columns...

Use a TAdoTable and set the TField's AutoGenerateValue := arAutoInc for your
identity field.

--
Michael Rodriguez
Compeat Restaurant Accounting Systems
http://www.compeat.com
m...@compeat.com

"Michael J. Austin" <maus...@hevanet.com> wrote in message
news:3b184ed3$1_1@dnews...

Quote

> All:

> I have SQL Server 7 tables that use identity columns. These columns are
not
> visible to user input. When I insert and then post, I get an "attempting
to
> update a non-nullable column with a null value." error. The identity
column
> is the only non-nullable column. I am using D5, ADO 2.5, and SQL Server 7,
> SP1. If I try to manually insert a row with Query Analyzer, of course it
> works fine.

> BTW, I am using TTables.

> It seems that this must be a problem with the TTable component or ADO.

> Any help appreciated.

> Mike

Vassil Nazaro

Delphi Developer

Sat, 22 Nov 2003 02:02:09 GMT

Re:Insert and Identity columns...

Quote

> Use a TAdoTable and set the TField's AutoGenerateValue := arAutoInc for your
> identity field.

This is a good idea as it is but it will not solve the problem. Also set the
Required property of the identity field to False.

HTH
--
Vassil Nazarov
IT Manager, Sofia Cable SA

Michael J. Austi

Delphi Developer

Tue, 25 Nov 2003 10:13:48 GMT

Re:Insert and Identity columns...

Thanks to both of you. I will give it a try.

Mike

Quote

"Vassil Nazarov" <vas...@mail.orbitel.bg> wrote in message

news:3b1bcd2c_2@dnews...

Quote

> > Use a TAdoTable and set the TField's AutoGenerateValue := arAutoInc for
your
> > identity field.

> This is a good idea as it is but it will not solve the problem. Also set
the
> Required property of the identity field to False.

> HTH
> --
> Vassil Nazarov
> IT Manager, Sofia Cable SA

Other Threads

1. MSSQL Identity columns, and Insert SQL

2. DELPHI ClientDataset Insert into MSSQL Table with IDENTITY Column Problem / Question

3. Insert using table with a identity column

4. Insert into Table with Identity column

5. Attempt to insert duplicate primary key error - identity column

6. How to insert in a row with an Identity column in SQL Server

7. IDENTITY column and INSERT

8. Need help with TQuery - inserting identity columns

9. How to make a column of an existing table into an IDENTITY column

10. Urgent!! PK violation when inserting into table with IDENTITY column as the PK column...