Inserting to a View - Auto Incrementing Issue

Hi,

My app has a model defined like this:

MyModel < ActiveRecord::Base   set_table_name "SOME_LEGACY_VIEW"   set_primary_key "LEGACY_ID" end

The Database is DB2. The view definition looks like this

SELECT     LEGACY_ID, NAME     FROM LEGACY_TABLE

When I create a new model and try to save it by doing this...

myModel = MyModel.new myModel.name = "TEST" myModel.save

Rails is creating an INSERT statement which includes the primary key - LEGACY_ID - set to an ampty String. This blows up auto-increment on LEGACY_TABLE.

Anyone seen this? Suggested solution.

Note - if LEGACY_ID is removed from the view it works OK, but I'm working with requirements that say it should be there.

Thanks.

Hi Paul,

Could you provide us the description of the LEGACY_TABLE (what is mainly wanted is the type of the column LEGACY_ID ). Also could you capture the insert statement that is being generated and paste it.

Thanks

Praveen