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. > On Nov 26, 2014, at 12:17 PM, tom <[email protected]> wrote: > > cant do that :-( > > > On Wed, Nov 26, 2014 at 12:13 PM, Colin Law <[email protected] > <mailto:[email protected]>> wrote: > On 26 November 2014 at 16:58, tom <[email protected] > <mailto:[email protected]>> wrote: > > 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? > > 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 > > -- > 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 [email protected] > <mailto:rubyonrails-talk%[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/CAL%3D0gLtsj86dWJU-Bw0byFwRBoNuHnEt1dDeyyj0R7b7EQaJzA%40mail.gmail.com > > <https://groups.google.com/d/msgid/rubyonrails-talk/CAL%3D0gLtsj86dWJU-Bw0byFwRBoNuHnEt1dDeyyj0R7b7EQaJzA%40mail.gmail.com>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > > -- > 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 [email protected] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/CADQqhMcmDvunXaxDuAoqmEj9aJztT_s9n%3DzqtJvJw0eyN1tKpg%40mail.gmail.com > > <https://groups.google.com/d/msgid/rubyonrails-talk/CADQqhMcmDvunXaxDuAoqmEj9aJztT_s9n%3DzqtJvJw0eyN1tKpg%40mail.gmail.com?utm_medium=email&utm_source=footer>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. ---- Jason Fleetwood-Boldt [email protected] 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 [email protected] with questions/concerns about this. -- 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 [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/BE19A371-0C5D-434C-A965-F15850C5B952%40datatravels.com. For more options, visit https://groups.google.com/d/optout.

