I have the BO, the view in the mdb, but if I call the BO Mapper tool, only tables are displayed.
Is it possible?
Thanks,
Alex B.
I want to populate the BO only for read purpouse, and the view I have in access is a union from 2 tables with some calculated fields (it's not only a talbe with a where filter).
I think it would be more simple to map the view directly to a BO and use this BO to populate my controls (it's a tree list).
Take a look at the following post, it may give you an idea of how to JOIN another table in the BO and then create some Custom Field Properties in your BO.
http://forum.strataframe.net/Topic14580-6-1.aspx?Highlight=join
Of course this is in case you will not be able to use your Access view directly in your BO which would be the easiest way for you.
We actually use OLEDB to talk to Access and call the GetSchema to return the views...apparently the Access OLEDB provider doesn't return views as a table. I can add this to a list to look at before the next update, but Edhy is correct in that you could create a query that does this form you.
Access has full ANSI 92 SQL support which means that you can use JOINs, etc, which is all that a view is doing for you anyway...especially as it relates to read-only data. Here is one post that I have recently talked about how to create an INNER JOIN: http://forum.strataframe.net/FindPost14603.aspx . (It is the same thread that Edhy mentioned).