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
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
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
cant do that
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.