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. var …

RemoteDB inserting records with Identity field

wlandgraf (Wagner Landgraf) June 2, 2022, 1:57pm 2

You can set the Required property of the Id field to False.

Topic		Replies	Views
RemoteDB / AutoInc field TMS RemoteDB	9	973	March 20, 2021
retrieve autoincrement TMS RemoteDB	3	223	May 19, 2023
How to obtain an autogenerated field value TMS RemoteDB	2	698	August 29, 2016
Identity insert during import TMS Aurelius	4	655	November 19, 2019
Insert record with specific id even when id field is IdentityOrSequence TMS Aurelius	3	277	July 14, 2020