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.
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to