HI



I'm using a 3rd party database, in the database design they put Schema as a company and in my SF application I have to change depends to the company I going to work to, but I do when I fill the BO and it still using the TableSchema property made by the BO Build.



Public Overrides ReadOnly Property TableSchema() As String

Get

Return "P_T_P"

End Get

End Property



Any suggestions how to change this are welcome.



Thanks SF

Perdo,



I think they are suggesting that in your BaseBO (if you aren't using one, now would be the time), you override the TableSchema property. Within it, you would then code the logic to change the db schema based on company. You could go about getting the company within the TaleSchema property in a number of ways. You would also add a company property to the BaseBO, or you could have a shared class that provide the current company info...I'm sure there are other ways too. Does that make more sense?

I know this is an old thread, but I have just come across the need to override the TableSchema property too, but I'm confused.  How can I override this property in a base level class when it's being overridden at a higher level in each business object's designer code?  Doesn't this just override my base class code then?   Thanks!