Hi everyone, I am novice using SQL.

I am migrating a MySQL DB with Delphi to an SQL 2008 with Delphi, the connection is running fine, but when I try to insert new records in some tables I get the Field must have a value error with the primary key of the table

I've already checked the properties with the ones that are working, but I can't find the difference

Instead of that can anyone explain me what to do please,

Thanks in advance for your help

Luis

Welcome to the forums.

The reason for that error is due to that field will not accept NULL or a default value is required.

So you have to list out that table properties by using SP_HELP to get more information.

 To insert data from delphi application , the table MUST have primary key.

check the primary keys for tables after migration. (sometimes migration don't create PK)