help with mssql sqlserver gem, table prefix

[tom]

hi

i have a sqlserver database with multiple companies in there. the table "prefix" give you the company name:

[CompanyA$Vendor].*

[CompanyB$Vendor].*

[CompanyC$Vendor].*

how can i address the right company with AR / sqlserver gem?

thx

[Colin Law]

The preferred solution would be to adjust the database schema so as to
fit the Rails Way. So have a companies table rather than multiple
tables with a prefix.

Colin

[tom]

cant do that :-(

Colin

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-ta...@googlegroups.com.
To post to this group, send email to rubyonra...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAL%3D0gLtsj86dWJU-Bw0byFwRBoNuHnEt1dDeyyj0R7b7EQaJzA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[Jason Fleetwood-Boldt]

Honestly if you can't conform to basics of what the ORM expects Rails is probably the wrong choice for you.

It sounds like you're trying to write a Rails app against an already existing database (which, I presume, already has other clients connected to it and changing data in it). This sounds like a bad idea. 

To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CADQqhMcmDvunXaxDuAoqmEj9aJztT_s9n%3DzqtJvJw0eyN1tKpg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

----

Jason Fleetwood-Boldt

te...@datatravels.com

http://www.jasonfleetwoodboldt.com/writing

All material © Jason Fleetwood-Boldt 2014. Public conversations may be turned into blog posts (original poster information will be made anonymous). Email ja...@datatravels.com with questions/concerns about this.