Hello, I am using a grid bound to and OA datasource and have set AllowUpdate, AllowInsert and AllowDelete all to true as this is a very simple grid providing a management of a reference table in the database. Nothing fancy required, although I have created an EditForm template to make things a little neater and to display a little help text on the form. The grid is also set to allow automatic inserts, updates and deletes.
The entity model defines the property JobTitle as nullable (as does the database) but I cannot get the OA datasource to pass null in the insert statement when the JobTitle textbox is left blank.
This is what is hitting the database:
'@p0 nvarchar(6),@p1 nvarchar(8),@p2 nvarchar(1)'
'INSERT INTO [Chair] ([chairFirstName], [chairLastName], [jobTitle]) VALUES (@p0, @p1, @p2)
I'm sure there is a simple way of doing this, but need a little inspiration please!