I have a Table, where the primary key is a auto increment datatype(Identity). Is it possible to populate that field in a dataset when the .insert method is called? I want the value to be know in my code, because doing the .post. I know this was possible with Firebird DB, maybe these components have something similar? Please help...
Code: Select all
CREATE TABLE [dbo].[Patient_Status](
[Patient_Status_Entry_ID] [int] IDENTITY(1,1) NOT NULL,
[Patient_Entry_ID] [int] NOT NULL,
[Status_Description] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_Status_Date] [datetime] NULL,
CONSTRAINT [PK_Patient_Status] PRIMARY KEY CLUSTERED
(
[Patient_Status_Entry_ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]