Error creating views in TB 2008

[giovannyq]

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

[Anonymous]

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