I am using the following code to insert new records in a table that has an Identity key field defined as [Id] [int] IDENTITY(1,1) NOT NULL
When inserting I get the message 'Field 'Id' must have a value'
As field Id is autoupdated when the record is created, how is this done using RemoteDB.
As far as I know, in MS SQL Server identity columns do not have a Required property, as implicitly allways automatically gets a new value as new records are created.
Do you know a hack to do what you are proposing.
It has been difficult to understand what you meant by the Required property, since I thought it was about modifying the field in the database, but now I have seen that it was about changing the property of this field in the recordset.
Once done, now it is working.
Thanks for your help.