ruby: 1.8.6 rails: 2.3.2 Database: Oracle 10g
Table with fields: ID varchar2(6) REC_NO number(10,0) (No primary key declaration)
Model: class Myclass < ActiveRecord::Base self.primary_key = 'rec_no' self.sequence_name = 's_rn_mytable' end
As you can see as described in the model there is a sequence in the DB that generates a unique number.
REC_NO is being used as "primary key" and should be receiving the unique generated value.
ID is used to store values (not unique) from another table.
When a record is created the value of ID is always nil with the model above. If I change the primary key description in the model and specify the column ID (self.primary_key = 'id') I can assign values to ID (although a varchar column the stored numbers are numeric so it lets me do it) but then REC_NO gets the value nil.
Is there a way to make this work the 'rails' way? I'd rather not use SQL, which allows me to create the records the way I need.
Thanks a lot.
Pepe
