# Saving to a table with computed fields

**URL:** <https://www.ruby-forum.com/t/saving-to-a-table-with-computed-fields/135541>\
**Category:** Rails\
**Created:** [April 23, 2008, 12:09am UTC](https://www.ruby-forum.com/t/saving-to-a-table-with-computed-fields/135541 "2008-04-23T00:09:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jessruby](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/d6d6ee/32.png) [@jessruby](https://www.ruby-forum.com/u/jessruby)\
**Post date:** [April 23, 2008, 12:09am UTC](https://www.ruby-forum.com/t/saving-to-a-table-with-computed-fields/135541/1 "2008-04-23T00:09:11Z")

</div>

Hi i just tried to save a record to a SQL Server that has a computed  
column and i get this error:

DBI::DatabaseError: 37000 (271) [unixODBC][FreeTDS][SQL Server]Column  
‘DLX\_DTMF’ cannot be modified because it is a computed column.: INSERT  
INTO DLXVOIPUSER ([DLXFILTER], [DLXLANG], [DLXPASS],  
[DLXBLOCK\_CALLER\_ID], [DLXMAX\_VM], [EXCHANCEPASS], [EXCHANGEUSERID],  
[DLXFIRST\_NAME], [DLXLAST\_NAME], [DLXVALIDAT\_DEL], [DLXEMAIL],  
[DLXDISPLAY\_NAME], [DLXVM\_TYPE], [DLXMAX\_DISK\_SPC],  
[DLXSKIP\_READVM\_PIN], [DLXWATCH\_BY\_DOM], [VOICEMAILPASS], [DLXAUTHMODE],  
[DLXTRUNCK\_TO\_TRUNCK\_CALL], [DLXTYPE]) VALUES(‘dialplan\_sitios\_lpz’,  
NULL, ‘32011a’, 0, 50, NULL, NULL, NULL, ‘a11023’, ‘a11023’, 1, NULL,  
NULL, 0, 5000, 1, 0, NULL, 1, 1, ‘U’)

How can i do not to write the DLX\_DTMF column

Thanks

---

<div class="post-metadata">

**Author:** ![jessruby](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/d6d6ee/32.png) [@jessruby](https://www.ruby-forum.com/u/jessruby)\
**Post date:** [April 23, 2008, 2:05am UTC](https://www.ruby-forum.com/t/saving-to-a-table-with-computed-fields/135541/2 "2008-04-23T02:05:55Z")

</div>

I just found this: [http://dev.rubyonrails.org/ticket/2944](http://dev.rubyonrails.org/ticket/2944)

Looks like this is a known issue. Sorry for not having a workaround  
handy…

Jan