I haven''t played around with it myself, but this might be a place to
start:
http://activewarehouse.rubyforge.org/rails_sql_views/
mfairchi wrote:> Hello,
> I have a legacy database in sqlserver 2005 that I am not allowed to
> change. I have tried using a view, as I have read it works for
> others, however I get an error.
>
> I have this in my model:
>
> class SheetEntryView < ActiveRecord::Base
> set_table_name ''Sheet_Entry_View''
> set_primary_key ''sheet_entry_KEY''
> end
>
> When I go to the console and try
> ->s=SheetEntryView
> ->SheetEntryView (Table doesn''t exist)
>
>
> I think part of the problem can be traced to this message in my log,
> SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE >
''BASE TABLE''
>
> Is there something else I need to configure in activerecord to allow
> it to work with sqlserver views?
>
> Thanks,
> Michael
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---