From: Rachel Nichol <rachel.nichol@...>
Date: 2009-06-30T23:50:05+09:00
Subject: Table Record on Sqlite3 DB Not Saving Updates

Does anyone have an idea of why the record for wsc_sort_order does not
keep the value when I try to set it equal to 2 through console?  Per
below?  I am stumped also - when first creating the record I had a
value for wsc_uid_pk, however, as you can see it is nil.



 >> cat2 = Webservcat.find_by_id(2)

=> #<Webservcat id: 2, wsc_uid_pk: nil, wsc_start_date: "2009-06-29",

wsc_active_fl: "Y", wsc_mult_serv_types_fl: "Y", wsc_sort_order: 1,

wsc_code: "INT", wsc_description: "INTERNET", wsc_end_date: nil,

wsc_system_code: "INT", created_at: "2009-06-29 20:01:43",
updated_at:

"2009-06-29 20:01:43">

 >> cat2.wsc_sort_order = 2

=> 2

 >> cat2.save

=> true

 >> cat2 = Webservcat.find_by_id(2)

=> #<Webservcat id: 2, wsc_uid_pk: nil, wsc_start_date: "2009-06-29",

wsc_active_fl: "Y", wsc_mult_serv_types_fl: "Y", wsc_sort_order: 1,

wsc_code: "INT", wsc_description: "INTERNET", wsc_end_date: nil,

wsc_system_code: "INT", created_at: "2009-06-29 20:01:43",
updated_at:

"2009-06-29 20:01:43">

 >>