Sql insert throws error

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


Hi Karthik

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


A quick search on google took me to this article. http://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?

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

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