I am getting an error when I attempt to add a record, with a table object,
to a SQL server database, via an ODBC link. I dont have SQL links. It seems
that it wants soemthing to filled into the identifier field, the only
problem is that if I do that SQL server returns an error that an illegal
attempt was made to insert a field (the identifier field) .

Except for trying a SQL query, is there any other option ?

When You do an "select * from animals" then you can use : Query.Open; But
when doing an
"insert into .............." then You have to use Query.ExecSQL;

Hope This helps

Felix

Johan L. Botha <j...@iafrica.com> wrote in article
<01bc5a64$92767f00$63921fc4@phoenix>...

Kallista has a Tech document that discusses issues with Delphi and MS
SQL 6.5. Goto thier web page (Kallista.com) under Tech and you should be
able to find a document called "Using Delphi with MicroSoft SQL Server
6.0" They mention issues with identity fields.

Steve Finner
OQS Software Design Inc.

Johan L. Botha <j...@iafrica.com> wrote in article
<01bc5a64$92767f00$63921fc4@phoenix>...

        Table1.Fields[F].Required := False;
        F equals the field number.
or
        Table1.FieldByName('name of field').Required := False;