I am trying to use DM to access SQL Server 2005 (with jruby). Everything seems to function properly, but now, I am trying to access de Catalog Views and it seems there is some problem with their names (all have a period in the name)
For example: I declare class Systable include DataMapper::Resource storage_names[:default] = 'sys.tables' property :name, String property :object_id, Integer, :key => true has n, :syscolumns, :child_key => :object_id end And then I have an SQL error The error is: Object name 'sys.tables' is not valid. (code: 208, sql state: S0002, query: SELECT "object_id", "name" FROM "sys.tables" ORDER BY "object_id", uri: ) The problem is that the name of the view has and embedded period and SQL Server tells it is invalid. Is there a way to workaround this issue? It works if I add another view to the database with a different name, but maybe there are some better alternatives. Thanks Juanma -- You received this message because you are subscribed to the Google Groups "DataMapper" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/datamapper?hl=en.
