View insertion failing

[Tripta Kaku]

Hi,

I am trying to insert into a view named 'request_files_v'. I get the error

"SQLSTATE[HY000]: General error: 1471 The target table request_files_v of the INSERT is not insertable-into".

I am giving the insert command from the same userid that had been used to define the view. Also, in information_schema.VIEWS, I see that the 'IS_UPDATABLE' field for this view is 'YES'.

What could be the possible reason I am not able to insert into this view?

Thanks in advance for any help !



Edited 1 time(s). Last edit at 02/10/2009 04:56AM by Tripta Kaku.