Rails - Dec 2010 - update a foreign key in an association table

Hello,

I''d like to know how to update a foreign key in an association table
(many_to_many association) ?

Here is my model, Split is the association table between Account and
Transaction:

class Account < ActiveRecord::Base
    set_primary_key :guid

    has_many :splits, :foreign_key => ''account_guid'',
:primary_key =>
''guid''
    has_many :transactions, :through => :splits
end

class Transaction < ActiveRecord::Base
    set_primary_key :guid

    has_many :splits, :foreign_key => ''tx_guid'',
:primary_key =>
''guid''
    has_many :accounts, :through => :splits
end

class Split < ActiveRecord::Base
    belongs_to :transaction, :foreign_key => ''tx_guid'',
:primary_key
=> ''guid''
    # here is the association that I''d like to change:
    belongs_to :account, :foreign_key => ''account_guid'',
:primary_key
=> ''guid''
end

I''m trying this but it does not work (the value is not updated):

account = Account.new
transaction.splits.first.account = account
# error: prints the old value of account
puts transaction.splits.first.account

Do you have any idea ? Do I need to create a new Split and delete the
old one or is it possible to update the existing one ?

Thank you for your help,

Fabrice

-- 
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.