giovannyq a écrit :
> Hi.
>
> I Need add feature labels in my MapGuide map for topobase web. The point and the attr tables are in different tables, need make a Join.
> In the information Manual appear this steeps.
>
> 1. create your view in Oracle
> 2. Add the view information in tb_dictionary table
> 3. Use the view
>
> But the system crash, and the connection with fdo is now is bad, and in the topobase admin appear an error about of attributes of tables does not exist.
>
> What is the solution?
>
> Thanks
> Sorry for my english
Hello,
You should try instead to use the join option you have in the data manager.
1/ use the data manager to add to the map the geographic data (the table
with SDO_GEOMETRY columns)
2/ in the data manager use the option to create a join between this new
"layer" and another Oracle table. Specify the join type you need.
3/ Once this is done, in the display manager, when changing the display
attribute, you will find (and be able to select) the columns from both
tables : the original one (with the SDO_GEOMETRY) and the joined tables.
Works ok, but add some processing usage...
Another option can be to add a layer from an ORACLE datasource (not a
TOPOBASE one). Then you will be able to build you view and select it.
But check that you have the latest release of the Oracle FDO provider.
Take it from a MapGuide release for example. The latest will allow you
to use a view (not only tables)... Or use the KING Oracle FDO Provider.
Charly