Muti Tenant Insert Query Error

Muti Tenant Insert Query Error

  

I started a muti tenancy app, switch from No to Yes

Created a Table with Message as only column

then I have a sql query

"INSERT INTO {Message} ([Message])
SELECT @In1"

Where @In1 is Var from a value from a textbox

But when I run the sql it gave this error:

                                                                                             

Error in advanced query SQL1 in Ok in HomePage in MainFlow in Muti (INSERT INTO {Message} ([Message])  SELECT @In1): The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint. The statement has been terminated.


What is going on?

Hello David,


Is there any compelling reason to insert data into the entity like that? I would go with the entity own actions..