Hi,
Please be gentle as I am new to this, but trying to insert a row into a table using simple sql statement
INSERT
INTO dbo.Cabinet_Fields (CabinetID, FieldID, Name, Type,Length) VALUES(40, 7,DOB,0,10)and I get:
Msg 128, Level 15, State 1, Line 2
The name "DOB" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.
I am able to add the row manually (not using SQL).
The Name field is type=nvarchar
Thanks