124
Views
4
Comments
Sql  insert throws error
Question

Hi ,

        When i try to insert a record using  sql systems throws the following error in development environment but same syntax insert record in personal environment




Thanks,

R.karthik


2018-06-19 09-34-03
flpmorais

Hi Karthik

Why are you performing a manual insert instead of just using the out-of-the-box create action?


UserImage.jpg
karthimani R

flpmorais wrote:

Hi Karthik

Why are you performing a manual insert instead of just using the out-of-the-box create action?


for inserting single record we need to do sql insert so that it will be useful for unit testing



2018-12-12 14-38-36
Afonso Aguas

A quick search on google took me to this article. https://zarez.net/?p=3002.

It seems you're trying to insert into a view some values which don't meet the criteria of the where/join clauses you have in that view.


Why are you trying to insert into a view anyways? Can't you insert into the tables that the view selects from?

2018-06-19 09-34-03
flpmorais

And additionally, is perhaps your production environment a multi-tenant environment?

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.