Hello all,
I have noticed that if you try to generate a store procedure for a table that does not have an identity field, the template will ignore any ReadOnly columns. Meaning, if I specify them as ReadOnly then I get a procedure generated that tries to account for the column on insert but doesn't pass the column in as a parameter.
In the sproc below, notice that TimeStamp is used but isn't a parameter, and I've set TimeStamp in the ReadOnlyColumns field of the CSLAStoredProcedure.cst
CREATE PROCEDURE [dbo].[ActionEC_Insert]
@ID int,
@Description varchar(2000)
AS
SET NOCOUNT ON
INSERT INTO [dbo].[Action] (
[ID],
[Description],
[TimeStamp]
) VALUES (
@ID,
@Description,
@TimeStamp
)
GO
Copyright (c) Marimer LLC