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

On Dec 1, 10:23 pm, Paul H. [email protected]

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs