Hi,



I have a following situation. I need to create a set of business objects which is mapped to either a VFP tables or SQL tables. However both set may have slightly different naming in the fields but content wise are the same. Can I achieve this?



Regards.

If your structures are going to be physically different, then you will need to either use a view of some sort or create two business objects.  You could manually create custom properties that pull from the proper structure depending upon the data source.  But this would require much more work. 

Hi Trent,



Are u suggesting to use custom fields? We have tried using OLE Provider but the object mapper does not show/allow views to be selected.



May I know how does the object mapper map the biz objects+fields to the table+fields? Is it stored in table or XML?



Regards

In these scenarios we use the Database Deployment Toolkit to create our structures, map to the DDT item, but never actually deploy the structure.  It is strictly for mapping the BOs.  I will look at the BO Mapper and see if there is something we can do to access the views, but in the mean time you may want to look at the video and sample about mapping to XML structures.  This may give you an idea or two.

http://forum.strataframe.net/Topic771-17-1.aspx 

Hi Trent,



To add on to my previous reply, can u give an example how u would do the following:



"then you will need to either use a view of some sort or create two business objects. You could manually create custom properties that pull from the proper structure depending upon the data source."





Regards

SQL Server views show up in the BO Mapper.  I will look into the VFP views and see why they do not appear.  As for the other, refer to my last post and watch the video on the business objects that use XML as a data source.  This is probably not the solution you are looking for, but it will give you some ideas on how you might go after this problem.

SQL Server views show up in the BO Mapper. I will look into the VFP views and see why they do not appear. As for the other, refer to my last post and watch the video on the business objects that use XML as a data source. This is probably not the solution you are looking for, but it will give you some ideas on how you might go after this problem.



Hi Trent,



I have watched the video and 1 question I am not clear how does the XML tie the backend database? Does it auto save intot backend whether it is SQLServer of VFP backend?



Is there going be a release this July and on schedule?



Regards