Hi,

I have a set of tables defined using DDT and one view. When I use the DDT as the data source for a business object all I see are the tables and the view is missing. Can you just confirm that this is incorrect and I should see views as well as tables. I presume I've done something wrong but, before I go chasing around, I would just like confirmation that DDT views are visible to business objects.

Cheers, Peter

Peter,

 

Views defined in DDT are not valid data sources for object mapper. You can use DDT to deploy the view to the database then use a SQL data source in object mapper to map your BO to the view. See the following link for more information.

 

http://forum.strataframe.net/Topic5732-6-1.aspx?Highlight=view

 

-Larry

Larry is right... if you want to use a view as the structure source for a business object, you have to map to the actual view within SQL Server... the BOMapper and DDT do not have the same sophisticated view syntax parsing that SQL Server uses, so you have to create the view first so we can pull the structure after SQL Server has parsed it.